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.

N802KCWakefield Aircraft LLC · Cooperstown, NDBuilt 2007 · S/N 802A-0262 N802KDKansas Farm And Ranch Inc · Seneca, KSBuilt 2013 · S/N 802A-0500 N802KFForest Flying Service Inc · Langdon, NDBuilt 2019 · S/N 802A0795 N802KJYuma Ag Air LLC · Yuma, COBuilt 2024 · S/N 802A-1098 N802KKWescoat Flying Services LLC · New Madrid, MOBuilt 2021 · S/N 802A-0902 N802KPAg Solutions LLC · Satanta, KSBuilt 2011 · S/N 802A-0397 N802KRDelta Air Inc · Belzoni, MSBuilt 2017 · S/N 802A-0726 N802LAAeronautical Technologies Inc · Clovis, NMBuilt 2001 · S/N 802A-0118 N802LBEverett Flying Service Inc · Holly Grove, ARBuilt 2014 · S/N 802A-0546 N802LGEvergreen Flying Service Inc · Dover, DEBuilt 2022 · S/N 802A-0981 N802LMJ&J Air Service LLC · Jonesboro, ARBuilt 2012 · S/N 802A-0452 N802LSJack Oldham Oil Inc · Dumas, TXBuilt 2019 · S/N 802A-0802 N802LTKansas Farm And Ranch Inc · Seneca, KSBuilt 2019 · S/N 802A-0785 N802MASug-Air LLC · Lubbock, TXBuilt 2002 · S/N 802A-0136 N802MBParrish Aerial Services LLC · Wilmington, DEBuilt 2018 · S/N 802A-0776 N802MFMcgarity Flying Service LLC · Sikeston, MOBuilt 2023 · S/N 802A-1012 N802MPProbasco Mitch · Floydada, TXBuilt 2018 · S/N 802A-0752 N802MTCartillar James R 3rd · Hickory Ridge, ARBuilt 2012 · S/N 802A-0445 N802NT & M Aircraft LLC · Monticello, ILBuilt 2009 · S/N 802A-0315 N802NBEast High Flying Inc · Warden, WABuilt 2016 · S/N 802A-0640 N802NDNorth Delta Ag Aviation LLC · Sledge, MSBuilt 2015 · S/N 802A-0597 N802NSCoppage Farm Services Inc · Braggadocio, MOBuilt 2016 · S/N 802A-0631 N802NTRba LLC · Kimberly, IDBuilt 2015 · S/N 802A-0596 N802NYNicks Flying Service Inc · Lagrange, INBuilt 2022 · S/N 802-0947 N802NZCo Fire Aviation Leasing · Fort Morgan, COBuilt 2022 · S/N 802A-0956 N802PPacific Valley Aviation Inc · Arbuckle, CABuilt 2017 · S/N 802A-0707 N802PAHangtime Investments LLC · Parma, MOBuilt 2015 · S/N 802A-0589 N802PFKade 802 LLC · Dumas, TXBuilt 2013 · S/N 802-0490 N802PPAg Air Care Inc · Wilmington, DEBuilt 2023 · S/N 802A-1035 N802PRHolcomb Aerial Services Inc · Flora, MSBuilt 2013 · S/N 802A-0533 N802QAWoodley Aerial Leasing LLC · Walnut, ILBuilt 2004 · S/N 802A-0194 N802QHT & M Aircraft LLC · Monticello, ILBuilt 1995 · S/N 802A-0025 N802RFAir Kraft Spraying Inc · Timber Lake, SDBuilt 2008 · S/N 802A-0306 N802RSPioneer Agviation 2 LLC · Holdrege, NEBuilt 2016 · S/N 802A-0634 N802RTDelta Dusters II LLC · Sledge, MSBuilt 2020 · S/N 802A-0823 N802SEAscend Ag Inc · Wall, SDBuilt 2024 · S/N 802A-1121 N802SGLocker Fred · Muleshoe, TXBuilt 2002 · S/N 802A-0135 N802SHMitchell Andrew D Trustee · Winnie, TXBuilt 2018 · S/N 802A-0750 N802SWNicks Flying Service Inc · Lagrange, INBuilt 2021 · S/N 802A-0903 N802SYFlite Level Zero LLC · Othello, WABuilt 2003 · S/N 802A-1060 N802TA3m Ag LLC · Ward, ARBuilt 2018 · S/N 802A-0741 N802TLObriens Flying Service Inc · Iowa, LABuilt 2019 · S/N 802A-0799 N802TPVisser Ag Inc · Rigby, IDBuilt 2016 · S/N 802-0665 N802TRSpears Aerial Crop Care LLC · Mamou, LABuilt 2011 · S/N 802A-0415 N802TSIntegrated Ag Services LLC · Stuart, FLBuilt 2015 · S/N 802A-0626 N802VJerry Price And Sons Inc · Joiner, ARBuilt 2023 · S/N 802A-1059 N802VARegenald Michaud Aviation LLC · Willows, CABuilt 2024 · S/N 802A-1109 N802VMDelta Dusters LLC · Epps, LABuilt 2016 · S/N 802-0670 N802WTri Rotor Spray & Chemical · Ulysses, KSBuilt 2011 · S/N 802A-0426 N802WEDakota Air Spray LLC · Huron, SDBuilt 2015 · S/N 802-0621

Back to AD 2001-10-04 R1