AD 2002-23-13
Registered aircraft · 3,462
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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.
N9898Aspen 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, CAN98FAHigher Purpose Aviaiton LLC · Spring Lake, MIN98HBEuroaviation Inc Trustee · KematenN98KQPilots To The Rescue Inc · Brooklyn, NYN98KSGuardian 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, NJN990JMCounty Of Galveston · Dickinson, TXN990LAMustang West Aero LLC · Midland, TXN990LRDavis Aviation Inc · Brandon, MSN990WTAmerican King Air LLC · Escalon, CAN991AKLake Clark Air Inc · Port Alsworth, AKN991LLState Of Illinois · Springfield, ILN992AFUas Transervices Inc · Boca Raton, FLN992AKLake Clark Air Inc · Port Alsworth, AKN992FEFederal Express Corporation · Memphis, TNN992LALane Aviation Inc · Rosenberg, TXN992MAJet Rider LLC · Wilmington, DEN993AKLake Clark Air Inc · Ports Alsworth, AKN993CBTri-Counties Bank · Chico, CAN993FEFederal Express Corporation · Memphis, TNN994AHAerospace Asset Holdings LLC · Wilmington, DEN994CFKk Air Leasing LLC · Tamarac, FLN994DF5 Blade Aero LLC · Firestone, CON994FEFederal Express Corporation · Memphis, TNN9956BMartinaire Aviation LLC · Addison, TXN995FEFederal Express Corporation · Memphis, TNN995GTJ&E Capital Partners LLC · Wilmington, DEN995JGMy Beaver LLC · Seattle, WAN995MKAviation Trust Company LLC Trustee · Oklahoma City, OKN995SPmg-Sr22t LLC · Greenville, NCN996FEFederal Express Corp · Memphis, TNN996QCHds Inc · Beech Grove, ARN997FEFederal Express Corporation · Memphis, TNN997JMLight Aircraft Leasing LLC · Menomonie, WIN997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCN997MDHaynes Aviation LLC · Wetumpka, ALN998FEFederal Express Corporation · Memphis, TNN998LMArmstrong Airlines Inc · Dover, DEN999CZN999cz LLC · Milwaukee, WIN999DZAlpine Aviation Inc · Provo, UT
Back to AD 2002-23-13