AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N6154HTravis Air Force Base Aero Club · Travis Afb, CAN6154MPeeler John · Cottonwood Heights, UTN6154PLonhart Donald E · Greeley, CON6154QViman LLC · Bear, DEN61557Angle Of Attack LLC · Boise, IDN6155DCurtis Jeremy A · Fairbanks, AKN6155JAnderdoc Aviation Inc · Wilmington, DEN6155KFreeway Airport Inc · Mitchellville, MDN6155LPeterson Walter R · Appling, GAN6155PSturm Steve G Trustee · Springdale, ARN6155QFixed Wing Holding Co Inc · Pembroke Pines, FLN61566Modin John · El Dorado Hills, CAN61567Enzyme Holdings LLC · Wilmington, DEN6156WHousley Steven W · Hot Springs, SDN6156XMathews Dale M · Fairbanks, AKN61571Engineers Flying Club Inc · Bethany, OKN61573Registered aircraftN61574Bruns Michael Wesley · Scottsdale, AZN61577Ingle Daniel B · Coraopolis, PAN6157DBadinelli Ralph D · Blacksburg, VAN6157FLa Placa Peter · Lake Havasu City, AZN6157JSale Reported · Columbus, OHSale reportedN6157LMelcher Robert L Trustee · Muskego, WIN6157PFrazier Jon A · Vista, CAN6157SKearley Christopher · Assonet, MAN6157WLaminar Skies Aviation LLC · Broken Arrow, OKN6157XBluesky Geospatial Ltd · North Adams, MAN61581Brat Equipment Co LLC · Slinger, WIN61585Mele Michael L · Fairview, ORN61586Evalt Ralph D II · Dillingham, AKN61588L&W Aircraft Investment LLC · Homestead, FLN6158GCag Aircraft Holdings LLC · Crystal River, FLN61594Hawk Aviation Inc · Rush City, MNN6159DDavis James J · Beaver Dam, WIN6159JSmathers James R Jr · Mission Viejo, CAN6159LLuciano Nicolas · Harlingen, TXN6159NCrothall George · Oceanside, CAN6159RBagamaspad Alan M · Reseda, CAN6159WSale Reported · San Luis Obispo, CASale reportedN615ADontje Robert E · East Moline, ILN615ADHill Douglas L · Berrien Springs, MIN615EREmbry-Riddle Aeronautical University Inc · Prescott, AZN615FTFlorida Institute Of Technology · Melbourne, FLN615JSPollak Steven D · Cincinnati, OHN615KAKoerner Alex J · Kankakee, ILN615MADowling Thomas · Mechanicville, NYN615PDRegistered aircraftN615PMMcclanahan Luke D · Midland, TXN615PSSanchez Peter J · Sioux Falls, SDN615RKKunz Russell G · Neosho, WI
Back to AD 81-18-04 R2