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.
N9613UGlenn Thomas Joel Hr · Fort White, FLN9613WAir Wilma LLC · Tijeras, NMN9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTN9614EWeber William J · Durham, NCN9614HC&H Elite Air LLC · Johnstown, CON9614JSkinner Roger · Delanson, NYN9614MSmith Michael O · Conroe, TXN9614QConrad Terry E · Lancaster, OHN9614SFlatonia Veterinary Clinic Inc · Flatonia, TXN9614WByrne Matthew A · West Allis, WIN9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCN9615DPeterson Thomas M · Park Rapids, MNN9615LHansen Aviation LLC · Savannah, GAN9615MMorgan Mark · Durango, CON9615RAlbright Frank · Elba, ALN9615TEtzel Gregory J · Lafayette, INN9615UKnutson Duane G · Brookings, SDN9615ZTampa Bay Soaring Society Inc · Zephyrhills, FLN9616ABoyd Ronald J · Genoa, CON9616JGarsteck Paula · Put In Bay, OHN9616LMid Island Air Service Inc · Ronkonkoma, NYN9616MBohn Aaron L · Valdosta, GAN9616QClearview Flying Club Inc · Westminster, MDN9616RPray Aviation Inc · Augusta, KSN9616WKohut Jeanette G · Southern Pines, NCN96177B2 Cpr Plus Inc · Bermuda Dunes, CAN9617CPete And Pete Sales Inc · Williamsville, NYN9617DWinton Christopher M · Valley Center, KSN9617HShinn Lake D · Stevensville, MTN9617JBeaverdam Aeronautics LLC · Chatom, ALN9617MSlusser Dennis G · Biggs, CAFirst renewal noticeN9617QKagin Corp · Wilmington, DEN9617SAnderson David R · Hastings, MNN9617WPoskevich Douglas P · Deland, FLN96180Jb Aviation · Bolingbrook, ILN96186Registered aircraftN9618DRich Beryl G · Brush Prairie, WAN9618FCoady Siegfried · Dallas, TXN9618MPatton Jeremy M · Dolores, CON9618SBradley Christopher · Juneau, AKN9618UN9618u LLC · Grand Haven, MIN96192Hannah Charles B · Skiatook, OKN9619BEuroaviation Inc Trustee · KematenN9619DSciotti Michael V · Wasilla, AKN9619JFlick Kristina R · Port Ewen, NYN9619LPeace Robert L II · Santa Fe, TXN9619SCulp Barney L Jr · Emerald Isle, NCN9619WId Rather Knot LLC · Louisville, KYN961AUAuburn University · Auburn, ALN961CLRegistration Pending · North Las Vegas, NVRegistration pending
Back to AD 81-18-04 R2