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.

N85CSAeronautical Technologies Inc · Clovis, NMBuilt 2023 · S/N 802A-1025 N862KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 802A-0826 N865DKKubecka Daniel P · Edna, TXBuilt 2022 · S/N 802A-0964 N865MGSugair LLC · Corpus Christi, TXBuilt 2012 · S/N 502B-2865 N865NFNew Frontier Aviation LLC · Fort Benton, MTBuilt 2012 · S/N 802A-0453 N867BFBunkie Flying Service Inc · Bunkie, LABuilt 2015 · S/N 802-0595 N867HCNe Ia Helicopter LLC · Tekamah, NEBuilt 2015 · S/N 802-0615 N867KHThree Flying Monkeys LLC · Sunray, TXBuilt 2017 · S/N 502A-3087 N867WAHildebrandt Ken M · Bethune, COBuilt 2022 · S/N 502A-3362 N867XPLdd Aviation LLC · Fort Worth, TXBuilt 2023 · S/N 502A-3417 N869HCPlane LLC · Grove, OKBuilt 2012 · S/N 802-0475 N869MLNew Frontier Aviation LLC · Fort Benton, MTS/N 802A-1294 N869SSWells Flying Services LLC · Holdrege, NEBuilt 2017 · S/N 802-0696 N870BBBottoms Up Flying LLC · Gould, ARBuilt 2023 · S/N 802A-1087 N870ESPrecision Air LLC · Dermott, ARBuilt 2025 · S/N 802A-1256 N870HFHutcherson Flying Inc · Forrest City, ARBuilt 2024 · S/N 802A-1176 N870JTBeta Fleet LLC · South Burlington, VTBuilt 2021 · S/N 802-0870 N870JWRice Ag Service Inc · Brinkley, ARBuilt 2025 · S/N 802A-1254 N870LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802-0270 N870MRRice Ag Service Inc · Brinkley, ARBuilt 2022 · S/N 802A-0999 N870SMAir Tractor Inc · Olney, TXS/N 502A-3646 N870SSRice Ag Service Inc · Brinkley, ARBuilt 2024 · S/N 802A-1179 N874MMAero S E A T Inc · Sterling, COBuilt 2021 · S/N 802A-0874 N874MRLoewen Air LLC · Park River, NDBuilt 2011 · S/N 402B-1239 N875JBAslesen Leasin LLC · Halstad, MNBuilt 2017 · S/N 802A-0725 N876LADcs Air LLC · Lewes, DEBuilt 2021 · S/N 802A-0876 N877LAMcginty Flying Service LLC · Jones, LABuilt 2013 · S/N 502B-2877 N8791SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0194 N879JAWallace Flying Service Inc · Atmore, ALBuilt 2013 · S/N 502B-2879 N8802EBravo Ag Air LLC · Belmond, IABuilt 2016 · S/N 802A-0630 N882ARoma Air Corp · Belle Glade, FLBuilt 2021 · S/N 802A-0882 N882KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 802A-0832 N883LATri-Rotor Spray And Chemical Inc · Ulysses, KSBuilt 2013 · S/N 502B-2883 N888HBAgri Air Industries Of Arkansas LLC · Paragould, ARBuilt 2021 · S/N 802A-0880 N8907SWoodley Aerial Leasing LLC · Walnut, ILBuilt 1979 · S/N 301-0230 N891WTBoettcher Aerial Co · Beloit, KSBuilt 2013 · S/N 502B-2906 N892BABrekke Aviation Inc · Edmore, NDBuilt 2024 · S/N 802A-1181 N892BMEvergreen Flying Service Inc · Dover, DES/N 802-0401 N893BMAir Tractor Inc · Olney, TXS/N 802A-1352 N895BMEvergreen Flying Service Inc · Dover, DEBuilt 2008 · S/N 802A-0301 N895LAC & L Holzwarth Inc · Virden, ILBuilt 2021 · S/N 802A-0895 N896WPWestern Pilot Service Inc · League City, TXBuilt 2013 · S/N 802-0504 N898ABBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 502B-3078 N898FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2021 · S/N 802A-0898 N898RBRba LLC · Kimberly, IDS/N 802A-1175 N898SRZumwalt Aviation LLC · Sheldon, ILBuilt 2020 · S/N 802A-0865 N89BMMilhon Air Inc · Martinsville, INBuilt 2009 · S/N 802-0323 N9002KAerial Timber Applicators Inc · Cooperstown, NDBuilt 1999 · S/N 802-0078 N9006QCrider Flying Service · Swifton, ARBuilt 1992 · S/N 502A-0190 N900LAFlying G Aviation Inc · Drayton, NDBuilt 2014 · S/N 502B-2957

Back to AD 2001-10-04 R1