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.

N507HBBruton Aerial Spraying Inc · Garden City, TXBuilt 2012 · S/N 502B-2810 N507KKKurtz Rural Aviation LLC · Mound City, MOBuilt 2026 · S/N 502A-3608 N507RLF&M Flying Service LLC · Columbus, MSBuilt 2018 · S/N 502A-3133 N5081WBarts Flying Service Inc · Storm Lake, IABuilt 1996 · S/N 401B-1013 N5085QScl Aviators · Wilmington, DEBuilt 1997 · S/N 402B-1047 N50877Arrow Aviation Inc · Broken Bow, NEBuilt 1997 · S/N 502B-0472 N508AKMoores Aerial Applicators LLC · Morehead City, NCBuilt 2021 · S/N 502A-3277 N508DGOld River Flying Service LLC · Wabash, ARBuilt 2013 · S/N 802A-0499 N508GKGeorges Aerial Spraying Service Inc · Sutton, NEBuilt 2021 · S/N 502A-3282 N508HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2012 · S/N 502B-2816 N508HMDt Pralle Enterprise Inc · Hampton, IABuilt 1994 · S/N 502B-0268 N5091NFarm Air Flying Service LLC · Sacramento, CABuilt 1997 · S/N 502B-0475 N50927Prairie Ag Service LLC · Des Arc, ARBuilt 1997 · S/N 402A-1041 N5092GSteinke Matthew · Gibson, IABuilt 1998 · S/N 502B-0515 N5094HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1998 · S/N 802A-0067 N509GFGibson Flying Service Inc · Marianna, ARBuilt 2020 · S/N 502B-3228 N509RKKurtz Rural Aviation LLC · Mound City, MOBuilt 2023 · S/N 502A-3429 N509RLLejeune Aerial Applications LLC · Basile, LABuilt 2017 · S/N 502A-3115 N509ZPNeal Aircraft Inc · Slaton, TXBuilt 2021 · S/N 802A-0931 N5100DTall Towers Aviation Inc · Page, NDBuilt 1997 · S/N 502B0412 N5109HAlexander Ag Flying Service Inc · Walnut Grove, CABuilt 1997 · S/N 502B-0460 N510XPMeyerkorth Aviation LLC · Rock Port, MOBuilt 2018 · S/N 502A-3128 N5110SChoctaw Flying Service Inc · Inverness, MSBuilt 1997 · S/N 402A-1043 N5110ZPonderosa Airtankers LLC · Safford, AZBuilt 1998 · S/N 802A-0060 N5119GTri-Air Farms LLC · Mamou, LABuilt 1997 · S/N 502B-0474 N511HBArthur Aviation LLC · Arthur, NDBuilt 2011 · S/N 502B-2754 N511LACavanaugh Flying Serivce Inc · Minden, NEBuilt 2007 · S/N 502B-2611 N5120EC & L Holzwarth Inc · Virden, ILBuilt 1998 · S/N 402B-1052 N5123UR & D Leasing Inc · Lemoore, CABuilt 1997 · S/N 802A-0053 N5124PIndependent Dusting Service Inc · El Campo, TXBuilt 1998 · S/N 402A-1051 N5127BFarmair LLC · Lagrange, INBuilt 1997 · S/N 502B-0437 N5128NBasin Aviation Inc · Rio Oso, CABuilt 1998 · S/N 402A-1054 N512LAWestern Pilot Service Inc · League City, TXBuilt 2009 · S/N 802A-0312 N512MPFarm Air Flying Service LLC · Sacramento, CABuilt 2014 · S/N 502B-2948 N513HBKansas Farm & Ranch Inc · Seneca, KSBuilt 2013 · S/N 502B-2901 N5144DKeo Ag Service Inc · Keo, ARBuilt 1998 · S/N 802A-0062 N5149TFitchs Flying Service LLC · Pearsall, TXBuilt 1998 · S/N 502B-0531 N514FAAir Tractor Inc · Olney, TXS/N 802A-1334 N514HBAurora Cooperative Elevator Co · Aurora, NEBuilt 2014 · S/N 502B-2978 N514LHGrowers Air Service Inc · Woodland, CABuilt 2012 · S/N 502B-2874 N5168FHallum Flying Service LLC · England, ARBuilt 1998 · S/N 502B-0520 N5175BMiller Aviation Inc · Norton, KSBuilt 1998 · S/N 402B-1084 N517SGWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 502B-3090 N517VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 502B-2750 N5190WMontague Aviation LLC · Inverness, MSBuilt 1999 · S/N 502B-0535 N5191BBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 402A-1094 N5192FJohnson Airspray Inc · Argyle, MNBuilt 1999 · S/N 402A-1093 N5195FRussell Charles B · Union City, TNS/N 502B-0552 N5196TCarlson Production Services LLC · Norcross, MNBuilt 1999 · S/N 502B-0556 N5197XJuliet Alpha Sierra LLC · Sartell, MNBuilt 1999 · S/N 502B-0571

Back to AD 2001-10-04 R1