AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N94DZHigh Desert Aero Holdings LLC · Portland, ORN94ERHill Andrew T · Smithville, TXN94FDBeaver Jonathan D · Greensboro, NCN94GCCook Gregory L · Carl Junction, MON94GWJ & J 327 LLC · Clare, MIN94HFDefenbaugh Matthew J · Biggsville, ILN94HHHarris Hill Soaring Corp · Horseheads, NYN94HJGable Taylor Lee · Nicholson, GAN94HUTronstad John L · Baker, MTN94HWLach John F · Warren, OHN94HYWest Metro Aviation LLC · Buffalo, MNN94KBBaker Bryn M · Clinton, UTN94KDSprik Robert J · Hamilton, MIN94KKKokemiller Kelley M · Boone, IAN94KWHine Garrett Christopher · Panama City Beach, FLN94LBWhetzel Russell R · Milford, NJN94LESky Path N94le LLC · Carmel, INN94LJFrostenson Bobi J · Fairfield, IDN94MBReese Elizabeth J · Glade Park, CON94MPMissouri State Highway Patrol · Jefferson City, MON94PLucas Matthew A · Mission Viejo, CAN94PKAshwill Gregory L Trustee · Overgaard, AZN94RTRoholt Philip C · Canton, OHN94SBBernatz Gerald F · Highland, ILN94SJMoe Alan D · North Bend, ORN94TBMartin Robert L III · Covesville, VAFirst renewal noticeN94TDKirk Tim L · Hilltop Lakes, TXN94TFWildblue LLC · Edgerton, MON94TSPetersen Andrew John · Saint Paul, MNN94TWCactus Skybolt Aviation LLC · Athens, ALN94VFPenhorwood Joshua M · Shubuta, MSN94WAVidal Aviation LLC · Gaithersburg, MDN94WDRegistration Pending · Sugar Grove, ILRegistration pendingN94WGAltruda Thomas Joseph · Las Vegas, NVN94WSParker Rob · Oklahoma City, OKN94XTaylor Samuel R · Kenai, AKN94YCBeauchene Mark J · Des Moines, IAN95008Ottaway Brent E · Derby, KSN9500DFlight Club LLC · Anchorage, AKN9500JMidwest Air Freight LLC · Sioux City, IAN9500LAtlantic Aero Club Inc · Newark, DEN9500MZoom Thusiasts LLC · Smyrna, GAN9500WRachel Calvin · Kimberly, ALN9501DBelof Joshua · Franklin, NCN9501JKnutson Donald W · Litchfield, MNN9501MCasterline Douglas J · Kansas City, MON9501PThumann Bruce E · Pasadena, TXN9501WAwwad Mamdouh A · Walnut Creek, CAN9502BGraceffa Salvatore · Atascadero, CAN9502HYoung Roger A II · Wasilla, AKFirst renewal notice
Back to AD 87-10-06 R1