Registered aircraft · 1,467

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.

N721LAAir Repair Inc · Cleveland, MSBuilt 2017 · S/N 802A-0721 N726RLLassco LLC · Middletown, DEBuilt 2023 · S/N 802-1019 N727CLSug Air LLC · Corpus Christi, TXBuilt 2014 · S/N 502B-2955 N729CFWells Flying Services LLC · Holdrege, NEBuilt 2000 · S/N 802A-0101 N729LARice Flying LLC · Corning, ARBuilt 2017 · S/N 802-0729 N729MWBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 502A-3234 N729PFRtc Aviation LLC · Munday, TXBuilt 2020 · S/N 802A-0857 N73005Mid Atlantic Ag LLC · Nassau, DEBuilt 1985 · S/N 400-0520 N73006Mid Continent Aircraft Corp · Hayti, MOBuilt 1985 · S/N 400A-0501 N7300EMark Gary Flying Service Inc · Inverness, MSBuilt 1984 · S/N 400-0517 N73070Lake Air Service LLC · Jennings, LABuilt 1999 · S/N 502B-0540 N7307TAas LLC · Ovid, MIBuilt 1985 · S/N 400-0610 N73080Tall Towers Aviation Inc · Page, NDBuilt 1985 · S/N 400-0639 N73084Precision Aerial Ag LLC · Seneca, KSBuilt 1985 · S/N 400-0638 N73085Woodley Aerial Leasing LLC · Walnut, ILBuilt 1985 · S/N 301-0636 N7308ADevil Dusters Inc · Artesia, NMBuilt 1985 · S/N 400-0624 N730JDSky Tech Inc · Dorchester, NEBuilt 2012 · S/N 502B-2819 N73127Georges Aircraft Repair · Vernon, TXBuilt 1987 · S/N 301-0667 N73132Headwaters Flying Service LLC · Three Forks, MTS/N 401-0670 N73135Mccormick Royce DBA · Seminole, TXBuilt 1987 · S/N 401-0671 N7314QTall Towers Ag Service Inc · Page, NDS/N 501-0004 N7314RNewberg Sky Spray LLC · Hector, MNBuilt 1987 · S/N 501-0005 N7315LSale Reported · Pelkie, MISale reportedBuilt 1987 · S/N 502-0006 N73194Schwenk Aircraft Inc · Appleton, MNBuilt 1988 · S/N 502-0014 N7319VTr Flying Service LLC · Milan, MNBuilt 1988 · S/N 502-0012 N731TJDcs Air LLC · Lewes, DEBuilt 2017 · S/N 802A-0731 N7320CKubecka Donald P · Seminole, TXBuilt 1988 · S/N 502-0015 N736LAFlatland Aviation LLC · Indianola, MSBuilt 2011 · S/N 502B-2736 N73LACameron Parish Mosquito Abatement · Creole, LABuilt 2006 · S/N 402B-1173 N740LALissie Flying Service Inc · Lissie, TXBuilt 2018 · S/N 802A-0780 N745LAKlein Flying Service Inc · Lawrenceville, ILBuilt 2018 · S/N 802A-0745 N746LAAnderson Farming Co · East Bernard, TXBuilt 2020 · S/N 802A-0828 N750LAWestwind Air LLC · Lake Village, ARBuilt 2022 · S/N 802A-0995 N753FAFarm Air Corp · Hoxie, ARBuilt 2013 · S/N 802A-0531 N754LAC & L Holzwarth Inc · Virden, ILBuilt 2018 · S/N 802A-0770 N756LARowland Dusters LLC · Raymondville, TXBuilt 2014 · S/N 502B-3005 N758LALowry Flying Service Inc · Grinnell, IABuilt 2024 · S/N 802A-1103 N765LAAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2011 · S/N 502B-2740 N767WPWestern Pilot Services Inc · League City, TXS/N 802A-0688 N769PBAirworks LLC · Sabin, MNBuilt 2009 · S/N 502B-2691 N772AAPro-Air LLC · Alexandria, LABuilt 2004 · S/N 502B-0691 N7742LBcm Flying Inc · Shelby, MSBuilt 2017 · S/N 802A-0693 N774MRSki Ag Aviation LLC · Bismarck, NDBuilt 2017 · S/N 502A-3084 N776ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 802A-0648 N778SBayou Dusters LLC · Moreauville, LABuilt 1994 · S/N 502B0267 N779DAAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802A-0779 N779DGRedline Aviation Inc · Sioux City, IABuilt 2023 · S/N 502A-3467 N780FAMd Aircraft Leasing LLC · Ripon, WIBuilt 2019 · S/N 802A-0807 N780NAAir Tractor Inc · Olney, TXS/N 802A-1333 N781FAAgwings Equipment LLC · Jonesboro, ARBuilt 2020 · S/N 802A-0860

Back to AD 2001-10-04 R1