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.

N804MWWoodard Flying Service Inc · Corning, ARBuilt 2022 · S/N 802A-0948 N804NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2017 · S/N 802A-0683 N804RATwist Air LLC · Turrell, ARBuilt 2015 · S/N 802A-0617 N804RXB&S Air Inc · Lumpkin, GABuilt 2019 · S/N 802A-0786 N804SESummer Agro Services LLC · Royal Palm Beach, FLBuilt 2025 · S/N 802A-1209 N804WWWhirlwind Aviation Inc · Fisher, ARBuilt 2016 · S/N 802A-0667 N8050UL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2017 · S/N 802-4030 N8050WL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4052 N8055HL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2025 · S/N 802-4055 N8057PMulder Air Inc · Renville, MNBuilt 2018 · S/N 802A-0778 N8057YL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2026 · S/N 802-4056 N8058LMontague Aviation LLC · Inverness, MSBuilt 2018 · S/N 802A-0743 N80595Standridge Flying Service Inc · Lake Village, ARBuilt 2025 · S/N 802A-1260 N805ASRice Flying LLC · Poplar Bluff, MOBuilt 2025 · S/N 802-1182 N805CBHog Air Aviation Inc · Paragould, ARBuilt 2016 · S/N 802A-0642 N805DGWakefield Aircraft LLC · Cooperstown, NDBuilt 2003 · S/N 802A-0156 N805ETArc Aviation Of Texas LLC · Winnie, TXBuilt 2012 · S/N 802A-0481 N805HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 802A-0570 N805KJDan'S Flying Service Inc · Crookston, MNS/N 502B-2805 N805KPTidwell Flying Service Inc · Carlisle, ARBuilt 2016 · S/N 802A-0673 N805NZHbair Co · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2017 · S/N 802A-0697 N805RXRegistration Pending · Norcross, MNRegistration pendingBuilt 2022 · S/N 802A-1001 N806BABombero Aviation LLC · Childress, TXBuilt 2016 · S/N 802-0644 N806EBDakota Air Spray LLC · Huron, SDBuilt 2013 · S/N 802A-0538 N806KPWild Rice Air Ag Inc · Rutland, NDBuilt 2017 · S/N 802A-0723 N806NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2018 · S/N 802A-0735 N807BBAgritec Aviation LLC · Deering, NDBuilt 2015 · S/N 802A-0584 N807HAAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2022 · S/N 802-0958 N807KPForest Flying Service Inc · Langdon, NDBuilt 2017 · S/N 802A-0730 N807NZHbair Co · Wilmington, DEBuilt 2017 · S/N 802A-0732 N807RXHog Air Aviation Inc · Paragould, ARBuilt 2023 · S/N 802A-1037 N808AMAero Seat Inc · Sterling, COS/N 802A-1275 N808HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2013 · S/N 802A-0498 N808MGMontague Aviation LLC · Inverness, MSBuilt 2012 · S/N 502B-2808 N808NZTwin Eagles Aviation Inc · Fort Mohave, AZBuilt 2019 · S/N 802A-0793 N808RXHog Air Aviation Inc · Paragould, ARBuilt 2023 · S/N 802A-1056 N809BBBear Bayou Ag Service Inc · Middletown, DEBuilt 2023 · S/N 802A-1090 N809CBHbair Co · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 2017 · S/N 802A-0709 N809KCMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2009 · S/N 802A-0347 N809NZCo Fire Aviation Inc · Fort Morgan, COBuilt 2019 · S/N 802A-0789 N809RXAg Air Aircraft Inc · Paragould, ARBuilt 2023 · S/N 802A-1080 N80PFProducers Flying Inc · Louise, MSBuilt 2020 · S/N 802-0864 N810EBRegenald Michaud Aviation LLC · Willows, CABuilt 2018 · S/N 802A-0767 N810KAJaj Flying LLC · Sutton, NEBuilt 2022 · S/N 502A-3350 N810RXNeal Aircraft Inc · Slaton, TXBuilt 2023 · S/N 802A-1072 N811APRegistered aircraftBuilt 2020 · S/N 802A-0855 N811TPJ & J Air Service LLC · Jonesboro, ARBuilt 2019 · S/N 802A-0814 N812ASRice Flying LLC · Poplar Bluff, MOBuilt 2025 · S/N 802-1191 N812EBRice Flying LLC · Poplar Bluff, MOBuilt 2020 · S/N 802A-0867 N812KAHowatt Air Inc · Langdon, NDBuilt 2012 · S/N 802A-0480

Back to AD 2001-10-04 R1