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.
N53291North Country Aviation Service LLC · Lewes, DEN5329SAlabama Forestry Commission · Montgomery, ALN532BZLicense2learn Aviation LLC · Port Orange, FLN532EREmbry-Riddle Aeronautical University Inc · Prescott, AZN532HFJet Air Inc · Iowa City, IAN532NDAia Bravo LLC · Henderson, NVN5330AGila Aviation LLC · San Luis, AZN5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeN53310Lucente Michael A · Fort Myers, FLN5331GAero Tech Services Inc · Lititz, PAN5331KChristiansen Aviation LLC · Wilmington, DEN5331TGilchrist William J · Hodges, SCN5332VMinuteman Aviation Inc · Missoula, MTN53340N53340 LLC · Boynton Beach, FLN5334KGlen Dale L · Ferndale, WAN5334UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN53352Fat Boy Air Sales & Leasing LLC · Naples, FLN5335GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN5335JFirst Eclipse Limited · Richmond, VAN5335SSpartan Education LLC · Tulsa, OKN53372Clover Park Technical College · Lakewood, WAN5338NRaritan Valley Flying School · Princeton, NJN5339MM&M Management Group LLC · Englewood, CON533BMGray Ronald P · Glendale, AZN533KSKent State University · Stow, OHN5340XAgvest LLC · Abingdon, VAN53417Eastern Cincinnati Aviation Inc · Batavia, OHN5341GRyno Works Inc · Mccall, IDN5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN5342TLima-001 LLC · Muscatine, IAN5342YAmeriflyers Of Texas Inc · Addison, TXN53440Air Spacers Inc · Santa Monica, CAN5344FWingsleasing LLC · Wichita, KSN5345UMidwest Avtech Inc · South Barrington, ILN53460L & W Leasing LLC · Smyrna, TNN53468Maya Aircraft Holdings LLC · Lee, NHN53474Executive Air Taxi Corp · Bismarck, NDN5348EDexter Brady R · Chambers, NEN5349HAviation Advisor Inc · Kenosha, WIN534DDVan Gasse Randall M · Norway, MIN534EREmbry Riddle Aeronautical University Inc · Prescott, AZN534HFSun Aircraft Management LLC · Ormond Beach, FLN534KSKent State University · Stow, OHN534RHAlf Ix LLC · Chicago, ILN5352ULittle Dog Aviation LLC · Anchorage, AKN5353RSouthern Illinois University · Murphysboro, ILN5355FFlight School Of Gwinnett Inc · Lawrenceville, GAN5355WN5355w Partners LLC · Lehi, UTN53569New Horizon Aviation Inc · Warwick, RIN5356PChristiansen Aviation LLC · Wilmington, DE
Back to AD 2003-24-13