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.
N975TBMiles High Flight Assets LLC · Atlanta, GAN9760BMartinaire Aviation LLC · Addison, TXN9761BMartinaire Aviation LLC · Addison, TXN9762BMartinaire Aviation LLC · Addison, TXN9766BRedding Aero Enterprises Inc · Redding, CAN976CWFisher Spray Service LLC · Cardington, OHN976EWright Air Service Inc · Fairbanks, AKN976FEFederal Express Corporation · Memphis, TNN977AAGuardian Flight Holdings Inc · Fairbanks, AKN977FEFederal Express Corporation · Memphis, TNN978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, CON978TSWaxhaw Flyers LLC · Rosedale, MSN979DKCatia Resources LLC · Garden City, TXN979FAReid Colby J · Broomfield, CON979FEFederal Express Corp · Memphis, TNN97DDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN97ESShiner Air LLC · Shiner, TXN97JFIsr Aviation LLC · Wilmington, DEN97KQInternational Air Services Inc Trustee · Carson City, NVN97TBNorth Atlantic Air Services LLC · Arundel, MEN97WCHf Air LLC · Hattisburg, MSN97WELawrence Aviation Inc · Austin, TXN980BCJet Rider LLC · Wilmington, DEN980DWRaven Aviation LLC · Fresno, CAN980FXFederal Express Corp · Memphis, TNN980MAFountainblu LLC · Wilmington, DEN981FEFederal Express Corporation · Memphis, TNN981LLState Of Il Dot · Springfield, ILN9820FPa1 208b-0410 LLC · Fort Lauderdale, FLN9829BSkydive Buckeye · Buckeye, AZN982GAMadaket Atlas LLC · Nantucket, MAN982KAircraft Guaranty Corp Trustee · Oklahoma City, OKN982SBCal-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, TNN986FEFederal Express Corporation · Memphis, TNN986MMGarrett Flying Service Inc · Danbury, TXN986WUS Government · Washington, DCN987CKHbc Air LLC · Wilmington, DEN987FEFederal Express Corporation · Memphis, TNN988SCPallair LLC · Harlingen, TXN988SPState Of New York · Latham, NYN988WCE S Wagner Co · Oregon, OHN9892Redditt Air Service Inc · Cleveland, MS
Back to AD 2002-23-13