AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.
N23KRUniversity Of Central Missouri · Warrensburg, MON23NPAia Foxtrot LLC · Henderson, NVN23SKPlainsman Aviation LLC · Kalispell, MTN23TLLottman Aviation LLC · Beatrice, NEN23VGPainted Horse Holding LLC · New Town, NDN23VMOrange Skies LLC · Great Falls, VAN23YPBmf Jax LLC · Jacksonville, FLN23YRP R Parker Company Inc · Shreveport, LAN2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKN2401AWhite Pat J · Wellington, TXN2405SJohn L Lyle Aviation LLC · Ridgeland, MSN2407NPhoenix East Aviation LLC · Daytona Beach, FLN2409ENutac Leasing LLC · Deland, FLN240CPCivil Air Patrol · Maxwell Afb, ALN240CSSem Assets LLC · Carrollton, TXN240CTCoast Flight Training & Management Inc · San Diego, CAN240DCWestbank Fishing LLC · Kiln, MSN240PSN240ps LLC · Mesa, AZN240TBN54za LLC · Houston, TXN24108Svetfur Aviation LLC · Camden, SCN24129Ssi Aviation Group LLC · Eagle, IDN2412WWestern Edge Aviation LLC · Dickinson, NDN2413M2021 Liberty Air LLC · Santa Rosa, CAN24144Edb Air Inc · Wilsonville, ORN2419RLynch Gerald A · Santa Barbara, CAN241ABTextron Aviation Inc · Wichita, KSN241AFState Of Louisiana · Baton Rouge, LAN241EPEpic Aviation Inc · New Smyrna Beach, FLN241JJN241jj LLC · Louisville, KYN241KRMako Offshore Exploration Inc · Pagosa Springs, CON241ME#430b LLC · Bruce Township, MIN241MPGv Air Inc · Medford, ORN24200Atp Aircraft 1 LLC · Wilmington, DEN24201Suhr Douglas Henry Jr · Oil City, PAN24204Atp Aircraft 1 LLC · Wilmington, DEN24205Atp Aircraft 1 LLC · Wilmington, DEN24207Atp Aircraft 1 LLC · Wilmington, DEN24210Atp Aircraft 1 LLC · Wilmington, DEN24213Career Track 1 LLC · Wilmington, DEN24215Career Track 1 LLC · Wilmington, DEN24218Career Track 1 LLC · Wilmington, DEN24219Career Track 1 LLC · Wilmington, DEN24221Career Track 1 LLC · Wilmington, DEN24222Career Track 1 LLC · Wilmington, DEN24223Career Track 1 LLC · Wilmington, DEN24226Career Track 1 LLC · Wilmington, DEN24236Career Track 1 LLC · Wilmington, DEN24237Career Track 1 LLC · Wilmington, DEN24238Career Track 1 LLC · Wilmington, DEN24239Career Track 1 LLC · Wilmington, DE
Back to AD 2003-24-13