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.
N871FBFreebird Leasing Group LLC · Sarasota, FLN871PDJohnson Aircraft Leasing LLC · Springfield, ILN872EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN872FALewis University · Romeoville, ILN872FSTfs Air LLC · Loveland, CON872SPChristiansen Aviation LLC · Wilmington, DEN873CPCivil Air Patrol · Maxwell Afb, ALN873EFFlorida Flight Training Center · Venice, FLN873MBKumar Ravin · Carson, CAN874EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN874LLLandry Raymond M · Georgetown, TXN875CPCivil Air Patrol · Maxwell Afb, ALN875DESoftcomm Aviation Inc · Irvine, CAN875PJEj Air LLC · Bel Air, MDN876EJEvans Ernest Levi Jr · Cary, NCN876EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN876MGAb Prop Plane II LLC · Metairie, LAN877AAFlx Flyers LLC · Farmington, NYN877CVBrown Joseph Glenn · Desert Hills, AZN877DWAviation Concepts LLC · Coeur D Alene, IDN8784TElizabeth City State University · Elizabeth City, NCN8789TChristiansen Aviation LLC · Wilmington, DEN878CPCivil Air Patrol · Maxwell Afb, ALN878EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN878MSProvidence Flying LLC · Chillicothe, MON878SATampa Bay Aviation Inc · Clearwater, FLN879CPCivil Air Patrol · Maxwell Afb, ALN879FZDon Davis Aviation Inc · Henderson, KYN879HZMewmew Investment LLC · Palo Alto, CAN879LPSpartan National Holdings LLC · Missoula, MTN879MTCfgn Aviation LLC · Molalla, ORN879WMPsl Surveys · Bristow, VAN87FFFf22 LLC · Scottsdale, AZN87GVChristiansen Aviation LLC · Wilmington, DEN87HFHeritage Asset Leasing LLC · Ronkonkoma, NYN87JAN87ja Lk Aircraft Holdings LLC · Wheeling, ILN87WTAnd We'Re Off Aviation LLC · Orlando, FLN880AFAmeriflyers Of Texas Inc · Addison, TXN880CPCivil Air Patrol · Maxwell Afb, ALN880EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN880SVDiamond Xport LLC · Rochdale, MAN880WSDepartment Of Inland Fisheries And Wildlife · Greenville, MEN881ACFly Twin Comanche LLC · Peoria, AZN881HPTurbine Conversions Ltd · Nunica, MIN881JFGriffin Aviation LLC · Minneapolis, MNN881LAAircraft Holdings LLC · Mesa, AZN881PAAtomic Partners LLC · Oak Ridge, TNN881SPIllinois State Police · Springfield, ILN882CPCivil Air Patrol · Maxwell Afb, ALN882EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FL
Back to AD 2003-24-13