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.

N256MSBuck N Aviation Inc · Fort Worth, TXNon-citizen corporation, flight hours not reportedBuilt 2021 · S/N 502A-3281 N257CAHorizon Air LLC · Lumpkin, GABuilt 2025 · S/N 802-1185 N261JBJb Leasing LLC · Norfolk, NEBuilt 2012 · S/N 502B-2813 N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265 N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268 N268TWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 502B-2727 N270TWMattern Rodney M DBA · Dawson, NDBuilt 2022 · S/N 502A-3367 N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471 N272DAAero Spray Inc DBA · Appleton, MNBuilt 2025 · S/N 802-1258 N272LAB & D Aircraft Leasing LLC · Waupun, WIBuilt 2018 · S/N 502B-3145 N273GCO'Briens Flying Service Inc · Iowa, LABuilt 2016 · S/N 502A-3073 N274ATBoardman Air Service LLC · Henderson, NEBuilt 2012 · S/N 402B-1251 N274BMEvergreen Flying Service Inc · Dover, DEBuilt 2026 · S/N 802A-1274 N275ATBoardman Air Service LLC · Henderson, NEBuilt 2025 · S/N 502A-3597 N275JAGibbs Aviation Inc · Fremont, OHBuilt 2011 · S/N 502B-2755 N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110 N277LAA & M Flying Service Inc · Carlisle, ARBuilt 2011 · S/N 502B-2777 N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953 N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281 N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201 N282XPProp Ag LLC · Montezuma, KSBuilt 2025 · S/N 502A-3573 N288KWFarm Air Inc · Astoria, ILS/N 802A-1288 N289JARiceland Aviation Inc · Jennings, LABuilt 2012 · S/N 502B-2809 N290LAAscend Ag Inc · Wall, SDBuilt 2018 · S/N 502A-3137 N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199 N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094 N297FAWalhalla Ag Service LLC · Walhalla, NDBuilt 2014 · S/N 502B-2973 N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398 N299JHJohnson Airspray Inc · Argyle, MNBuilt 1990 · S/N 4010726 N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276 N3025PDakota Air Spray LLC · Huron, SDBuilt 2013 · S/N 502B-2896 N302PCAerial Crop Protection Inc · Belle Glade, FLBuilt 2020 · S/N 502B-3267 N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283 N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602 N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509 N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507 N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284 N30411Farm Air Inc · Astoria, ILBuilt 2014 · S/N 502B-2914 N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520 N30523R & R Flight Service Inc · Mendota, ILBuilt 2013 · S/N 502B-2934 N30539Midwest Aerial Spraying LLC · Dorchester, NEBuilt 2013 · S/N 502B-2936 N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525 N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535 N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305 N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529 N3063HBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 502B-2943 N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524 N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549 N3066VMurtagh Flying Service Inc · Lexington, MSBuilt 2014 · S/N 502B-2965 N30674Jlw Aviation Inc · Carlisle, ARBuilt 2014 · S/N 802A-0557

Back to AD 2001-10-04 R1