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.

N62764Bell Flying Inc · Newport, ARBuilt 2020 · S/N 802A-0859 N627LANew Frontier Aviation LLC · Fort Benton, MTBuilt 2005 · S/N 802A-0213 N628FAAkbj LLC · Lewes, DES/N 802A-0641 N629JPLj Leasing LLC · Cardington, OHBuilt 2002 · S/N 802A-0129 N630MAMeyers Air Service LLC · Superior, NEBuilt 2014 · S/N 502B-2963 N637LAMaxwell Flying Service Inc · Benoit, MSBuilt 2001 · S/N 502B-0637 N638TWRedline Ag LLC · Mount Vernon, MOBuilt 2008 · S/N 502B-2638 N639LAJ & R Flying Service LLC · Alicia, ARBuilt 2016 · S/N 802A-0639 N63AWAmerican Ag Aviation Inc · Five Points, CABuilt 1998 · S/N 802A-0063 N641SMRiverside Air LLC · Shelby, MSBuilt 2023 · S/N 802A-1064 N647LACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 502B-2647 N648LALane Aviation Inc · Rosenberg, TXBuilt 2002 · S/N 502B-0649 N656FAAir Tractor Inc · Olney, TXS/N 502B-3647 N658LAPontiac Flying LLC · Pontiac, ILBuilt 2003 · S/N 502B-0658 N661MAAramco Capital Company LLC · DhahranBuilt 1998 · S/N 802A-0057 N662JKFairmont Aerial Ag Inc · Frost, MNBuilt 2009 · S/N 502B-2662 N662MAAramco Capital Company LLC · DhahranBuilt 1996 · S/N 802-0037 N663LAAurora Cooperative Elevator Co · Aurora, NEBuilt 2003 · S/N 502B-0663 N663MAAramco Capital Company LLC · DhahranBuilt 2014 · S/N 802-0552 N665UHartley Flying Service Inc · Stuttgart, ARBuilt 2019 · S/N 802A-0783 N667CBDevil Dusters Inc · Artesia, NMBuilt 2003 · S/N 502B-0667 N670BFBrb LLC · Lewes, DEBuilt 2025 · S/N 802A-1214 N670RBOver The Top Aviation Inc · Jonesboro, ARBuilt 2021 · S/N 802A-0875 N672LAGarrett Flying Service Inc · Danbury, TXBuilt 2021 · S/N 802A-0926 N674LAFerriday Flying Service Inc · Ferriday, LABuilt 2018 · S/N 802A-0774 N676DKSovereign Skies LLC · Russell, KSBuilt 2016 · S/N 502A-3052 N676LASchlater Ag Air LLC · Minter City, MSBuilt 2009 · S/N 502B-2676 N677LAWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2011 · S/N 502B-2738 N67AGA & L Farm Services Inc · Helena, ARBuilt 2017 · S/N 802-0686 N684LARegistered aircraftBuilt 2017 · S/N 802A-0684 N687LA5g'S Aviation LLC · Trumann, ARBuilt 2017 · S/N 802A-0687 N688JB4j A/C Leasing LLC · Port Saint Lucie, FLBuilt 2012 · S/N 502B-2871 N692MPWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 502A-0182 N694SVTejas Flying Services LLC · Ganado, TXBuilt 2010 · S/N 502B-2694 N697JATactical Agriculture LLC · Upper Sandusky, OHBuilt 2010 · S/N 502B-2697 N69FYTexoma Ag LLC · Corsica, SDBuilt 2023 · S/N 802A-1015 N69VCPro Agri Spraying Service Inc · Ropesville, TXBuilt 2022 · S/N 802A-0945 N701NTPioneer Agviation 2 LLC · Holdrege, NEBuilt 2012 · S/N 502B-2824 N702LAJesse Shipman Farms LLC - Series A · Honey Grove, TXBuilt 2004 · S/N 502B-0702 N703NAMcelwain Russell · Lancaster, KSBuilt 2024 · S/N 802A-1133 N705LABank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 502A-2707 N710LAJefferson Davis Parish Mosquito Abatement Dist #1 · Jennings, LABuilt 2010 · S/N 502B-2711 N711FUNeal Aircraft Inc · Slaton, TXBuilt 2016 · S/N 802A-0650 N711NACkw Aviation LLC · Dalhart, TXBuilt 2025 · S/N 802A-1202 N712GSAt402 LLC · Banquete, TXBuilt 2007 · S/N 402B-1189 N716FAFarm Air Corp · Minturn, ARBuilt 2014 · S/N 802A-0576 N717DAAero Spray Inc DBA · Appleton, MNBuilt 2008 · S/N 802A-0303 N718MLRice Flying LLC · Poplar Bluff, MOBuilt 2020 · S/N 802-0830 N71BMEvergreen Flying Service Inc · Dover, DES/N 802A-1271 N71HKSak IV LLC · Brookings, SDBuilt 2025 · S/N 802A-1186

Back to AD 2001-10-04 R1