AD 2012-19-01
Registered aircraft · 51,501
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:2012-19-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-19-01')
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:2012-19-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-19-01') 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.
N104DHPiper Aircraft Inc · Vero Beach, FLN104DMMcalee Dennis E · Defiance, MON104DPMajul Enterprises Inc · Saint Petersburg, FLN104EHaas Bruce F · Lynden, WAN104EDEdwards Aero Club · Edwards Afb, CAN104EEWestfall Benjamin C · Coeur D Alene, IDN104EGSpitzer Helicopter LLC · Wilmington, DEN104EPEarwood Edward A · Sonora, TXN104EREmbry Riddle Aeronautical University · Daytona Beach, FLN104GDFiebiger Mark D · Leesburg, FLN104GKIndigo Bunting Aviation LLC · Morristown, NJN104GRMargolis David · Tucson, AZN104HPGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN104HYGlenn Heath · Ranger, TXN104JASkywest Leasing Inc · Saint George, UTN104JBF2 Aviation & Marine Assets LLC · Solana Beach, CAN104JGRoscioli Lamberto · Lighthouse Point, FLN104JWGobeli Michael T · East Lyme, CTN104KGKing & Co LLC · Arroyo Grande, CAN104LDMasys Daniel R · Lincoln, CAN104LJFeldhousen Larry A · Burlington, CON104LULynn University Inc · Boca Raton, FLN104MEMathis Mark D · Richmond, TXFirst renewal noticeN104MFEccker Donald E · Ramona, CAN104MJLift Drag Aviation LLC · El Cajon, CAN104MQL C Whitford Co Inc · Wellsville, NYN104MRMccurdy Mark L · Tucson, AZN104MXFrancis Scott P · Montclair, VAN104NRainey Norman W · Surprise, AZN104PBMountain Flight LLC · Missoula, MTN104PKKreuter Paul E · Goshen, INN104PSDepartment Of The Interior · Boise, IDN104RGWeiss Elliott · Fresno, TXN104SJLockard John D · Oceanside, CAN104TEN104te LLC · Tucumcari, NMN104TTTucker Thaddeus D · Wilder, IDN104USHartenstine Michael C · Lancaster, CAN104WHGreycal Enteprrises Inc · Lake Mary, FLN104XLeider Robert G · Washoe Valley, NVN104XPRv X Aviation LLC · Draper, UTN104ZURuttler James J · Bremerton, WAN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1050RWatrous Scott A · Warrenton, VAN1051SWhitfield David Michael · Cleveland, GAN1051TOwens Randall C · Houston, TXN1051WAir Services International Leasing LLC · Fort Lauderdale, FLN1051ZDranttel Timothy John · Fuquay Varina, NCN1052TSale Reported · Crystal, MNSale reportedN1052UHuizinga Reinder C · Marietta, GA
Back to AD 2012-19-01