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.
N230KGAlf Ix LLC · Chicago, ILN230SAStature Aviation LLC · Addison, TXN23104Atp Aircraft 1 LLC · Wilmington, DEN23107Atp Aircraft 1 LLC · Wilmington, DEN23108Atp Aircraft 1 LLC · Wilmington, DEN23110Atp Aircraft 1 LLC · Wilmington, DEN23116Atp Aircraft 1 LLC · Wilmington, DEN23118Atp Aircraft 1 LLC · Wilmington, DEN23120Atp Aircraft 1 LLC · Wilmington, DEN23122Atp Aircraft 1 LLC · Wilmington, DEN23124Atp Aircraft 1 LLC · Wilmington, DEN23127Atp Aircraft 1 LLC · Wilmington, DEN23134Career Track 2 LLC · Wilmington, DEN23137Career Track 2 LLC · Wilmington, DEN2315BSkylane Air LLC · Sarasota, FLN2315WAviation Partners LLC · Chesapeake, VAN2316TAircraft Solutions Group LLC · Englewood, CON23172Career Track 2 LLC · Wilmington, DEN23175Career Track 2 LLC · Wilmington, DEN23176Career Track 2 LLC · Wilmington, DEN23177Career Track 2 LLC · Wilmington, DEN23182Costello Lisa · The Woodlands, TXN2318LButerbaugh Richard A · Summerville, SCN231EPEpic Aviation Inc · New Smyrna Beach, FLN231PABone Jason T · Bulverde, TXN231RGTextron Aviation Inc · Wichita, KSN231SPIowa State Patrol · Des Moines, IAN23203Wings Over Texas Holdings LLC · Denton, TXN23207Ttp Aviation LLC · Concord, NCN23215Bill Webb Construction Inc · Chico, CAN2322YIn Flight Aircraft LLC · Howell, MIN2323ZCalahan Spencer H · Baton Rouge, LAN2328RYoung Airmans Association Inc · Arverne, NYN232AFState Of Louisiana · Baton Rouge, LAN232EPEpic Aviation Inc · New Smyrna Beach, FLN232ESBayside Beach Resort LLC · Tavernier, FLFirst renewal noticeN232FFArq Aviation LLC · Wilmington, NCN232JMWillfish LLC · Mentor, OHN232MEDunbar Joseph · Greensboro, NCN232MJNby Productions · Bristow, VAN232SBEagle Crest 2sb LLC · Milton, DEN232TJCsc Delaware Trust Co Trustee · Wilmington, DEN232ZVance Jordan Enterprises Inc · Wilmington, DEN2330FFlight Operations Aircraft LLC · Wilmington, DEN2334GHegna David E · Wall Township, NJN2334JThree Four Juliet LLC · Orange, CAN2335UDolphin Leasing LLC · Daytona Beach, FLN2336VW Tech Consulting Inc · Wilmington, DEFirst renewal noticeN23383Performance Auto Body Inc · Knightdale, NCN2338VLima 001 LLC · Muscatine, IA
Back to AD 2003-24-13