AD 2016-19-13
Registered aircraft · 960
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:2016-19-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-19-13')
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:2016-19-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-19-13') 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.
N818LWLeveled Wings LLC · Calabasas, CAN818THWilmington Trust Co Trustee · Wilmington, DEN819EXPreserve Air LLC · Honolulu, HIN81HMIheart Media Management Services Inc · New York, NYN81SNK S Blackwood Properties II LLC · Midland, TXN822NPProductivity Strategies LLC · Olathe, KSN823RCDodson International Parts Inc · Rantoul, KSN824SMeregrass Inc · Dublin, TXN825WKMadunn El LLC · Wayzata, MNN826APApi Aviation LLC · New Brighton, MNN826KAircraft Fidelity Corp Trustee · Dover, DEN827UBcu 2000 LLC · Pleasant Prairie, WIN828MLWalkabout Air Inc · Tampa, FLN82BULacore Adventures LLC · Melissa, TXN830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CAN831DRDriscolls Inc · Watsonville, CAN831MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN833JBImt Holdings Management Co LLC · Sherman Oaks, CAN83HDHomerlease Co Inc · Atlanta, GAN83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN844UPUnion Pacific Railroad Co · Omaha, NEN845UPUnion Pacific Railroad Co · Omaha, NEN846UPUnion Pacific Railroad Co · Omaha, NEN84HDHomerlease Co Inc · Atlanta, GAN84PHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN84PJHampton Airways Inc · Sellersburg, INN850ENBcbg Capital LLC · Clearwater, FLN850FJPachy Music Corp · Bellflower, CAN850TCRt Falcon Enterprises LLC · Bloomfield Hills, MIN851MJet Plane Management LLC · Saint Paul, MNN855DGDollar General Corp · Goodlettsville, TNN855TJLark Aviation LLC · Reno, NVN857SSSimon Aviation LLC · Birmingham, MIN85HDHomerlease Co Inc · Atlanta, GAN85TNLls Aviation LLC · Nederland, TXN860PSLbma Equipment Services Inc · Newburgh, NYN865CSReef Aviation LLC · Knoxville, TNN865PKPilot Travel Centers LLC · Knoxville, TNN865WWRegistered aircraftN868AADcco Aviation II LLC · Canton, MIN868EMDcco Aviation II LLC · Canton, MIN868SHHca Squared LLC · Nashville, TNN86HDHomerlease Co Inc · Atlanta, GAN86TNBravo Aviation LLC · Santa Rosa Beach, FLN870ARFtc Air Holdings LLC · Tampa, FLN870SBSimmons First National Corp · Little Rock, ARN874VTGolden Goat LLC · Southern Pines, NCN878MMCentury Skies LLC · Englewood, CON87HDHomerlease Co Inc · Atlanta, GAN87KBKkb Holdings LLC · Wilmington, DE
Back to AD 2016-19-13