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.

N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087 N332BSHog Air Aviation Inc · Paragould, ARBuilt 2019 · S/N 802A-0791 N332LAHoran Spraying LLC · Plainview, TXBuilt 2019 · S/N 502A-3188 N333BRB&R Aerial Crop Care Inc · Connell, WABuilt 2022 · S/N 802A-0989 N334BSMitchell Andrew D Trustee · Winnie, TXS/N 802A-0521 N334LASun Valley Dusting Co · San Benito, TXBuilt 2019 · S/N 502B-3187 N335BSOld River Flying Service LLC · Helena, ARBuilt 2016 · S/N 802A-0643 N335LAAir Tractor Inc · Olney, TXS/N 802-1335 N335QFBearcreek Flying Service LLC · Oakes, NDBuilt 2013 · S/N 802A-0522 N337MAMeyers Aerial Service LLC · Superior, NEBuilt 2014 · S/N 502B-3010 N339BSB & S Air Inc · Lumpkin, GABuilt 2020 · S/N 802A-0839 N340LATri-Air Farms LLC · Mamou, LABuilt 2009 · S/N 802A-0349 N341LALake Washington Flying Service Inc · Glen Allan, MSBuilt 2022 · S/N 502B-3341 N344VAAir Tractor Inc · Olney, TXS/N 802A-1344 N347BMAir Tractor Inc · Olney, TXS/N 802A-1347 N347ERO'Briens Flying Service Inc · Iowa, LABuilt 2022 · S/N 802A-0944 N347REAir Tractor Inc · Olney, TXS/N 802A-1331 N349ASAero Applicators Inc · Sterling, COBuilt 2015 · S/N 802A-0603 N350DAAir Tractor Inc · Olney, TXS/N 802A-1354 N354FSAnderson Interests LLC · East Bernard, TXBuilt 2010 · S/N 802A-0355 N358ASNew Frontier Aviation LLC · Fort Benton, MTBuilt 2015 · S/N 802A-0604 N3636BAir Tractor Inc · Olney, TXS/N 502B-3636 N363ATAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802A-0508 N363GSParrish Aerial Services LLC · Wilmington, DEBuilt 2015 · S/N 802-0587 N3650DWoodley Aerial Leasing LLC · Walnut, ILBuilt 1980 · S/N 302-0240 N3652ZCotton Ag Inc · Walters, OKBuilt 1980 · S/N 400-0256 N3654GDixie Flying Service Inc · Bradley, ARS/N 400-0281 N3655BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1980 · S/N 301-0291 N3655TPutz Gary D · Hearne, TXS/N 301-0300 N3657TCentral Planes Aviation Inc · Sauk Centre, MNBuilt 1980 · S/N 301-0316 N3659NHoppe Air LLC · Beaman, IAS/N 400-0294 N365LAFarm Air Corp · Minturn, ARBuilt 2010 · S/N 802A-0365 N369AB3rd Gen Aviation LLC · Lisbon, NDBuilt 2008 · S/N 502B-2653 N369ZPRegistration Pending · Pasco, WARegistration pendingBuilt 2025 · S/N 802A-1253 N370JBAurora Cooperative Elevator Co · Aurora, NEBuilt 2011 · S/N 802A-0399 N371LABruton Aerial Spraying Inc · Garden City, TXBuilt 2018 · S/N 502A-3177 N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636 N376ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0607 N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377 N379ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0609 N385LABrunetti Finley Jr · Shelby, MSBuilt 2010 · S/N 802A-0385 N386LAHinkle Airspray Inc · Cavalier, NDBuilt 2010 · S/N 802A-0386 N389LABailey Air LLC · Delhi, LABuilt 2010 · S/N 802A-0389 N392KWSpradin Flying Service Inc · Petersburg, TXBuilt 2007 · S/N 802A-0282 N393LAC&L Holzwarth Inc · Virden, ILBuilt 2024 · S/N 802A-1093 N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242 N396LANeal Aircraft Inc · Slaton, TXS/N 802A-0331 N397LAWil-Co Flying Service LLC · Dewitt, ARBuilt 2009 · S/N 802A-0332 N398ASAero Spray Inc DBA · Appleton, MNBuilt 2014 · S/N 802A-0564 N398LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802A-0263

Back to AD 2001-10-04 R1