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.
N25184Career Track 5 LLC · Wilmington, DEN25187Career Track 3 LLC · Wilmington, DEN25188Career Track 3 LLC · Wilmington, DEN25189Career Track 5 LLC · Wilmington, DEN25191Textron Aviation Inc · Wichita, KSN25194Career Track 3 LLC · Wilmington, DEN25199Career Track 5 LLC · Wilmington, DEN251AUPeregrine Howard Partners II Lp · New Orleans, LAN251CACivil Air Patrol · Maxwell Afb, ALN251DPDisa Air LLC · Laredo, TXN251DWWallin Aviation LLC · Taylorsville, UTN251EPEpic Aviation Inc · New Smyrna Beach, FLN251MECavu Aircraft Group LLC · Green Cove Springs, FLN251SFCgc Prop Plane 1 LLC · Metairie, LAN251SMTextron Aviation Inc · Wichita, KSN25200Career Track 3 LLC · Wilmington, DEN25204Career Track 5 LLC · Wilmington, DEN25205Career Track 5 LLC · Wilmington, DEN25206Megwetch Aviation LLC · Auburn, MEN25208Career Track 5 LLC · Wilmington, DEN25212Career Track 5 LLC · Wilmington, DEN25213Career Track 5 LLC · Wilmington, DEN25218Career Track 5 LLC · Wilmington, DEN25220Career Track 5 LLC · Wilmington, DEN252AFState Of Louisiana · Baton Rouge, LAN252CPCivil Air Patrol · Maxwell Afb, ALN252EJJohnson Eldridge Jr · Chicago, ILN252EPEpic Aviation Inc · New Smyrna Beach, FLN252JRJrr LLC · Fort Lauderdale, FLN252JSVan Bortel Aircraft Inc · Arlington, TXN252LTAerownership North American Services Inc Trustee · Wilmington, DEN252QCCereberus LLC · Lewes, DEN252SMFlying Scot LLC · Raleigh, NCN252SPSkysuite Aviation LLC · Tujunga, CAN252VKRobert Thomas Properties LLC · Caro, MIN253EPEpic Aviation Inc · New Smyrna Beach, FLN253JGFly Good Land Gooder Holdings LLC · Tomah, WIN253TSAlf Ix LLC · Chicago, ILN253WPEastern Cincinnati Aviation Inc · Batavia, OHN254CETextron Aviation Inc · Wichita, KSN254CSVallencourt Construction Co Inc · Green Cove Springs, FLN254EKBellers Aviation Inc · Fremont, CAN254EPEpic Aviation Inc · New Smyrna Beach, FLN254SFAb Prop Plane I LLC · Metairie, LAN254SPAtp Aircraft 2 LLC · Wilmington, DEN255ATThompson Aaron R · Louisville, KYN255CETextron Aviation Employees Flying Club Inc · Wichita, KSN255EPEpic Aviation Inc · New Smyrna Beach, FLN255FLCoutts Dylan A · Windsor, MEN255MEFalbo Michael Wayne · Sellersburg, IN
Back to AD 2003-24-13