AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N872FTeachout Caleb · Chesterfield, MIN872KBBruner Kevin G · Vandalia, OHN87304Mackie Kevin S · Longview, WAN87308Cato James W · Las Cruces, NMN8730SDederer Laura · Valencia, PAN8730UKachalsky Alan N · Rye, NYN87312Lademann Ryan C · Saint Clair Shores, MIN8731GCard James D · Mc Cool, MSN8731SLawrenz Richard A · Mcpherson, KSN8731USemet Marva S · Seattle, WAN87321Wiger Theodore L · Falcon Heights, MNN87323Cardwell Gregory D · Cameron Park, CAN8732GPerkins Robert A · New Richmond, WIN8732UHumke John D · Eufaula, OKN87330Maison Taisiya E · Olney, MDN87336Abreu David A · Del Rio, TXN87340Eleazer Robert W III · Merritt Island, FLN87346Bryson Stephen Mark · Corsicana, TXN87348Howard Dale L · Harrisburg, NCN8734UGrow Aviation LLC · Aurora, NEN87359Manning Gary · Newalla, OKN8735UJkh Aviation LLC · Cumming, GAN8736BCampbell Jack G · Spring Valley, WIN8736GSantana Amaury · Winter Haven, FLN8736UC & M Aviation Holdings LLC · Brockport, NYN87374Gregory Vernon L · Swansea, SCN8737BFranklin Rodney S · Burns, ORN8737UMiss Lou Flight LLC · Vidalia, LAN8738URhk Of Kansas · Jefferson City, MON87391Specht Leo M · Towner, CON8739GKlott William D · Morris, ILN8739HShaw Brian W · Bemidji, MNN8739UAndrews Willard R · Windham, MEN873XJOnken Richard · Hastings, NEN87405Specht Leo M · Towner, CON8740BOltrogge Construction Inc · Absarokee, MTN8740SBucks Flight Academy LLC · Cashion, OKN87410Harpole Bill · Dickinson, NDN87416Amann David Paul · Wesley Chapel, FLN8741BPhoenix Air Inc · Orland Park, ILN8741GDahlberg James C · Ogilvie, MNN8741SJohnson Zachary R · Burien, WAN8741USexton Mathew G · Rockwell City, IAN87426Safety-Net LLC · Salem, INN8742BTexas Wings LLC · San Antonio, TXN8742GReeve Howard E · Minot, NDN8742UJennings Jeff L · Kenly, NCN87433Four Five Air LLC · Traverse City, MIN87435Owen Nick F · Jacksboro, TXN87449Korzelius Matthew J · Niagara Falls, NY
Back to AD 94-05-05 R1