AD 2016-05-13
Registered aircraft · 3,126
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-05-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-05-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-05-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-05-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.
N97WCHf Air LLC · Hattisburg, MSN97WELawrence Aviation Inc · Austin, TXN980BCJet Rider LLC · Wilmington, DEN980FXFederal Express Corp · Memphis, TNN980MAFountainblu LLC · Wilmington, DEN981FEFederal Express Corporation · Memphis, TNN981LLState Of Il Dot · Springfield, ILN9820FPa1 208b-0410 LLC · Fort Lauderdale, FLN9829BSkydive Buckeye · Buckeye, AZN982ASAbove Standard Flying Service LLC · Tallulah, LAN982GAMadaket Atlas LLC · Nantucket, MAN982MRSky Tech Inc · Dorchester, NEN982SBCal-Ore Life Flight LLC · Brookings, ORN982TMAt Aero LLC · Wilmington, DEN9838ZN B B S LLC · Kansas City, KSFirst renewal noticeN983ARS2c LLC · Wilmington, DEN983FEFederal Express Corporation · Memphis, TNN984FEFederal Express Corporation · Memphis, TNN984MAExtraordinary Air LLC · Greenville, SCN985ABSafford Aviation Service Inc · Coolidge, AZN985FEFederal Express Corporation · Memphis, TNN985JBFarmair LLC · Lagrange, INN986FEFederal Express Corporation · Memphis, TNN986WUS Government · Washington, DCN987FEFederal Express Corporation · Memphis, TNN988SCPallair LLC · Harlingen, TXN988WCE S Wagner Co · Oregon, OHN9892Redditt Air Service Inc · Cleveland, MSN9898Aspen Air Montana LLC · Albuquerque, NMN9899Registered aircraftN989BWRed Dragon Aviation LLC · Melbourne, FLN989FEFederal Express Corporation · Memphis, TNN989SAAir Kraft Spraying Inc · Timber Lake, SDN98ARRyan Gordon Air LLC · Santa Ana, CAN98KSGuardian Flight LLC · Lewisville, TXN98MNMohawk Northeast Inc · Plantsville, CTN98NFTanner Air LLC · Oxford, MSN98PMTcp One LLC · Amarillo, TXN98VKFb Aviation Services LLC · Wilmington, DEN98WPWalsh Aviation LLC · Midland, TXN990CBB & G Aircraft LLC · Flanders, NJN990LAMustang West Aero LLC · Midland, TXN990LRDavis Aviation Inc · Brandon, MSN990WTAmerican King Air LLC · Escalon, CAN991LLState Of Illinois · Springfield, ILN992AFUas Transervices Inc · Boca Raton, FLN992FEFederal Express Corporation · Memphis, TNN992MAJet Rider LLC · Wilmington, DEN993CBTri-Counties Bank · Chico, CAN993FEFederal Express Corporation · Memphis, TN
Back to AD 2016-05-13