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.

N1004BJames R Cartillar III · Hickory Ridge, ARS/N 501-0022 N1004FAeroag LLC · Portland, INBuilt 1988 · S/N 502-0025 N1005MAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1302 N1005NMadsen Travis E · New Underwood, SDBuilt 1988 · S/N 401-0692 N1005VGb Spraying LLC · Bridgeport, NEBuilt 1988 · S/N 402-0694 N1006YG B Aerial Applications Inc · Slaton, TXS/N 502-0031 N10078Dallas Aero & Sales LLC · Poplar, MTBuilt 2013 · S/N 502B-2881 N1007WAir Cover LLC · Frankford, MOBuilt 1988 · S/N 502-0032 N1008FMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1988 · S/N 502-0033 N1008QTall Towers Aviation Inc · Page, NDBuilt 1988 · S/N 401-0702 N1009LSouther Field Aviation Inc · Americus, GABuilt 1989 · S/N 502-0036 N1010LDevil Dusters Inc · Artesia, NMBuilt 1989 · S/N 401-0708 N10114Hoppe Air LLC · Beaman, IAS/N 502-0043 N10122Aero Spray Inc · Appleton, MNBuilt 2013 · S/N 802A-0495 N10125North Delta Ag Aviation LLC · Sledge, MSBuilt 1989 · S/N 502-0047 N10126Quiver River Flying LLC · Doddsville, MSBuilt 1989 · S/N 502-0050 N10129Parrish Aerial Services LLC · Wilmington, DEBuilt 1989 · S/N 502-0051 N1012BMidwest Aerial Applicators LLC · Whittington, ILBuilt 1989 · S/N 402-0712 N1012TJohnson Airspray Inc · Argyle, MNS/N 401-0719 N1012ZBuffalo Aviation LLC · Monette, ARBuilt 1989 · S/N 502-0044 N1013FCorpora Aerial Service Inc · Hearne, TXBuilt 1989 · S/N 401-0721 N1013NVal Air 2 LLC · White River, SDS/N 401-0722 N1013STr Flying Service LLC · Milan, MNBuilt 1989 · S/N 401-0724 N1014NFrontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0729 N1015AFrontier Agricultural Service Inc · Calexico, CAS/N 401-0735 N1015LInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 401-0730 N1017XAaa Aviation LLC · Donalsonville, GABuilt 1989 · S/N 402-0734 N10185Oli Grow LLC · Baskin, LABuilt 1989 · S/N 502-0063 N10189Whalen Mark P · Millington, MDBuilt 1989 · S/N 402A-0738 N10192Frontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0731 N1019SBuffalo Ridge Airspray LLC · Milbank, SDS/N 502-0066 N1021BBeachy Flying Service LLC · Whittington, ILBuilt 1989 · S/N 502-0062 N1022NBoyle Flying Service Inc · Boyle, MSS/N 502-0071 N1025AAas LLC · Ovid, MIBuilt 1990 · S/N 502-0075 N1035LSwope Cattle Inc · Anahuac, TXS/N 502-0080 N1036WSouther Field Aviation Inc · Americus, GABuilt 1989 · S/N 502-0041 N103LALove Aero LLC · Leland, MSBuilt 2001 · S/N 402A-1133 N1041WRiverside Air LLC · Shelby, MSBuilt 2020 · S/N 802A-0858 N1055FWbd Flying LLC · Sondheimer, LABuilt 2011 · S/N 502A-2751 N105TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 502A-3352 N106LAVisser Ag Inc · Rigby, IDBuilt 2001 · S/N 802A-0106 N107MLMike Ogan Farms · Pierre, SDBuilt 2012 · S/N 402B-1250 N108TFWood Flying Inc · Panhandle, TXBuilt 2008 · S/N 502B-2652 N10TPAeronautical Technologies Inc · Clovis, NMBuilt 2006 · S/N 802-0246 N1101PJerry Price & Sons Inc · Joiner, ARBuilt 2024 · S/N 802A-1101 N110BHBighorn Flying Co LLC · Wood River, NEBuilt 2001 · S/N 402A-1135 N1122RRegistered aircraftBuilt 2019 · S/N 802A-0794 N112FAFast Ag Air LLC · Watertown, SDBuilt 2025 · S/N 802A-1199 N112HBD&D Aerial LLC · Gratiot, WIBuilt 2012 · S/N 502B-2825 N114WLThompson Flying Service LLC · Charleston, MOBuilt 2014 · S/N 502B-2960

Back to AD 2001-10-04 R1