Registered aircraft · 1,468

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

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:2001-10-04-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1') ORDER BY n_number

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:2001-10-04-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1')
  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:2001-10-04-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-10-04-R1')
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.

N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491 N20607Neal Aircraft Inc · Slaton, TXBuilt 2012 · S/N 802A-0439 N2060HCleveland Air Service Inc · Cleveland, MSBuilt 2013 · S/N 802A-0497 N2060MAerial Crop Protection Inc · Stuart, FLBuilt 2012 · S/N 802A-0437 N2064JPadgett Ag Rotors LLC · Missoula, MTS/N 802-0450 N2065SSteggs Aerial Spraying Inc · Alva, OKBuilt 2012 · S/N 802A-0487 N2066EEdwards Flying Service Inc · Leland, MSBuilt 2012 · S/N 502B-2826 N2067EFarm Air Flying Service LLC · Sacramento, CABuilt 2012 · S/N 802A-0440 N20700Meyerkorth Aviation LLC · Rock Port, MOBuilt 2012 · S/N 802A-0486 N20718Cartillar Enterprises Inc · Wynne, ARS/N 802A-0465 N20726A&M Flying Service Inc · Carlisle, ARS/N 802A-0468 N2072DPadgett Ag Rotors LLC · Missoula, MTBuilt 2012 · S/N 402B-1268 N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207 N208VVT&T Highcountry Flying Service LLC · Saint Anthony, IDS/N 502B-0560 N2094MCmk Aerial Inc · Sutton, NEBuilt 2011 · S/N 502B-2756 N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409 N211CHRegistered aircraftS/N 802A-1278 N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212 N212FBAero Spray Inc DBA · Appleton, MNBuilt 2010 · S/N 802A-0368 N213BHBighorn Flying Co LLC · Wood River, NEBuilt 2013 · S/N 402B-1279 N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896 N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843 N2254LPhoenix Equipment Lc · Nickerson, KSBuilt 1985 · S/N 400-0611 N226DHCottonwing Air LLC · Indianola, MSBuilt 2010 · S/N 502B-2726 N226FBLipan Creek Flying Service LLC · Eola, TXBuilt 2024 · S/N 802A-1157 N228RGA+ Aviation Services LLC · Garden City, KSBuilt 2009 · S/N 402B-1223 N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965 N22WHAeronautical Technologies Inc · Clovis, NMBuilt 1997 · S/N 802A0039 N2306ABlanke Jason F · Mandeville, LABuilt 1981 · S/N 400-0345 N23416Woodley Aerial Leasing LLC · Walnut, ILBuilt 1981 · S/N 301-0385 N2347PDakota Air Spray LLC · Huron, SDBuilt 1981 · S/N 301-0388 N23618Aerinova Aerial LLC · Mattoon, ILBuilt 1981 · S/N 400-0402 N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408 N23744Van Horne Robert E · Centralia, ILBuilt 1982 · S/N 400A-0429 N23813Davis Blake A · Bellevue, TXBuilt 1982 · S/N 400A-0433 N2393NMid Mo Ag Air LLC · Boonville, MOS/N 400-0441 N2394NAssociated Aerial Applicators Inc · La Salle, COBuilt 1982 · S/N 400A-0446 N23951Rowland Dusters LLC · Raymondville, TXS/N 400A-0447 N23WTAeronautical Technologies Inc · Clovis, NMBuilt 2014 · S/N 802-0568 N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240 N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375 N243LAH & G Farms Inc · Corcoran, CABuilt 2015 · S/N 502B-3020 N244PWAdams Aerial Solutions LLC · Decatur, ILBuilt 2024 · S/N 502A-3494 N246BRRoberts Ag Air Service Inc · Lamoure, NDBuilt 2012 · S/N 502B-2786 N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400 N247LFWilliamsburg Air Service Inc · Kingstree, SCBuilt 2022 · S/N 502A-3395 N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444 N249LABank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 502A-3049 N252LABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 502B0252 N254LAObriens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3054

Back to AD 2001-10-04 R1