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.

N519CKAgwerx Aviation Inc · Yuma, COBuilt 2025 · S/N 802A-1183 N520LASunnyside Aero Inc · Schlater, MSBuilt 2021 · S/N 502B-3293 N520SDBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2014 · S/N 502B-2956 N520XPAurora Cooperative Elevator Co · Aurora, NEBuilt 2020 · S/N 502A-3229 N521LACollinston Air Service Inc · Oak Ridge, LABuilt 2014 · S/N 502B-3011 N521XPAurora Cooperative Elevator Co · Aurora, NEBuilt 2020 · S/N 502A-3237 N522LAWallin Michael · Walnut Ridge, ARBuilt 2015 · S/N 802A-0622 N522LLRegenald Michaud Aviation LLC · Willows, CABuilt 2013 · S/N 802-0532 N522MPMoore Randy · Floydada, TXS/N 502B-3236 N523BFPadgett Ag Rotors LLC · Missoula, MTBuilt 2017 · S/N 802A-0689 N523RBAnderson Interests LLC · East Bernard, TXBuilt 2014 · S/N 802A-0575 N526FAAir Tractor Inc · Olney, TXS/N 802A-1338 N5272TIndependent Dusting Service Inc · El Campo, TXBuilt 2022 · S/N 402B-1469 N527ATH&G Farms Inc · Corcoran, CABuilt 2022 · S/N 502B-3396 N527FRRoma Air Corp · Belle Glade, FLBuilt 2016 · S/N 802A-0681 N527PKAir Care Leasing LLC · Lamar, COBuilt 1998 · S/N 402A-1067 N528MBPorter Flying Service LLC · Missoula, MTS/N 802A-0350 N530CMPacific Valley Aviation Inc · Arbuckle, CABuilt 2017 · S/N 802A-0680 N532BAAslesen Leasin LLC · Halstad, MNBuilt 2008 · S/N 402A-1200 N532MCAlpha Ag Air LLC · Little River, KSBuilt 2005 · S/N 502B-2594 N535MCMcintyre Flying LLC · Angleton, TXS/N 802A-0526 N543LAZimmer Christopher P · Upham, NDBuilt 2023 · S/N 502A-3437 N550GCSouth Delta Aviation LLC · Grace, MSBuilt 1997 · S/N 402A-1037 N550WFRoth Aerial Spraying LLC · Milford, NEBuilt 2014 · S/N 502B-2972 N554MARkjm LLC · Superior, NEBuilt 2023 · S/N 802A-1011 N557CFH & G Farms Inc · Corcoran, CABuilt 2016 · S/N 802A-0668 N557MAMeyers Aerial Service LLC · Superior, NEBuilt 2025 · S/N 802A-1246 N558LAWilmot Airplane Ventures LLC · Mer Rouge, LABuilt 2024 · S/N 802A-1158 N562LASturdivant Brothers Flying Service Inc · Glendora, MSBuilt 2017 · S/N 802A-0708 N563LANicks Flying Service Inc · Rolling Fork, MSBuilt 2017 · S/N 502A-3094 N569BHPrecision Air LLC · Dermott, ARBuilt 2024 · S/N 802A-1161 N569LAMoses Lake-Warden Air Service Inc · Moses Lake, WABuilt 2014 · S/N 802A-0569 N56HFKeeter Jerry · Olney, TXBuilt 2005 · S/N 402B-1161 N573LAWade Aviation Inc · Calhoun City, MSBuilt 2005 · S/N 502B-2573 N573SMMcgarity Flying Service LLC · Sikeston, MOBuilt 2023 · S/N 802A-1078 N576FFDt Pralle Enterprise Inc · Hampton, IAS/N 502B-0668 N581TWVisser Ag Inc · Rigby, IDBuilt 2005 · S/N 502B-2581 N58589Mattern Rod · Napoleon, NDBuilt 2021 · S/N 502A-3294 N5935Ponderosa Airtankers LLC · Safford, AZBuilt 1996 · S/N 802A-0035 N595JWWiebe Aerial Applications LLC · Whitewater, KSBuilt 2009 · S/N 502B-2663 N595RSWillmar Aerial Spray Inc · Olivia, MNS/N 802A-1284 N598BAWestern Ag Aviation Inc · Plains, KSBuilt 2013 · S/N 402B-1272 N598LASale Reported · Clinton, ARSale reportedS/N 502B-2598 N599BAWerth Lance · Johnson Lake, NEBuilt 2013 · S/N 402B-1302 N6000JAndy Riddell Flying Service Inc · Marvell, ARBuilt 2010 · S/N 802A-0376 N6000YA+ Aviation Services LLC · Goodland, KSBuilt 1995 · S/N 401B-0983 N6002HTumbleweed Leasing LLC · Tacoma, WABuilt 2010 · S/N 802A-0380 N6002TH & C Consulting LLC · Wilmington, DEBuilt 2010 · S/N 802A-0390 N6003GPrecision Ag Air LLC · East Prairie, MOS/N 502B-0249 N60057Sunflower Aero Inc · Atwood, KSBuilt 1994 · S/N 401-0951

Back to AD 2001-10-04 R1