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.

N445HAAir Tractor Inc · Olney, TXBuilt 2016 · S/N 802-0633 N445MSAas LLC · Ovid, MIBuilt 1994 · S/N 502B-0237 N448LAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2012 · S/N 802A-0448 N45019Aerial Solutions Of Tennessee LLC · Milan, TNBuilt 1990 · S/N 502-0090 N4501QConfederate Air Inc · Mcgehee, ARS/N 502-0086 N4509STall Towers Ag Service Inc · Page, NDBuilt 1990 · S/N 502-0088 N45113Over And Under Flying Service Inc DBA · Knox, INBuilt 1990 · S/N 502-0094 N45116Macys Flying Service Inc · Tulelake, CABuilt 1990 · S/N 401-0752 N45123Wood Flying Inc · Panhandle, TXS/N 402-0753 N4513WForest Flying Services Inc · Langdon, NDS/N 401-0754 N4515AB&R Aerial Crop Care Inc · Connell, WAS/N 502-0095 N45196Boettcher Aerial Inc · Beloit, KSS/N 402-0755 N4523LWiebe Albert · Seminole, TXS/N 402-0757 N4525QAg Flyers Inc · Torrington, WYS/N 502-0100 N4527XSug-Air LLC · Lubbock, TXS/N 402A-0758 N4528LSkyworks Aviation LLC · Waynesboro, GAS/N 402A-0759 N45313Registration Pending · Southampton, NJRegistration pendingS/N 502-0103 N4532FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0769 N4535UCga Holdings LLC · Kalispell, MTS/N 401-0773 N45363South Delta Aviation Inc · West Helena, ARS/N 402-0774 N45368Atlantic Ag Aviation Inc · Felton, DEBuilt 1990 · S/N 401-0775 N4536QHoppe Air LLC · Beaman, IAS/N 502-0106 N4537XPontiac Flying LLC · Pontiac, ILS/N 502-0110 N4539BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 401-0763 N4539YHylands Agricultural Services LLC · Gretna, NES/N 401-0779 N4540FWoodley Aerial Leasing LLC · Walnut, ILBuilt 1990 · S/N 402-0784 N4540YTlc Flying Inc · Colfax, WABuilt 1990 · S/N 502-0120 N4541SKankakee Valley Aviation LLC · Wanatah, INS/N 402-0778 N45421Ascend Ag Inc · Wall, SDS/N 401-0786 N45461Shannon Agricultural Flying Inc · Clarksdale, MSBuilt 1990 · S/N 502-0124 N45469Over & Under Flying Service Inc · Madison, INBuilt 1991 · S/N 402A-0797 N45472Rtc Aviation LLC · Munday, TXBuilt 1991 · S/N 402A-0794 N4547QFarm Air Inc · Quanah, TXS/N 401-0792 N45492Woodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 401-0801 N4549EVertical Vegetation Management LLC · Darlington, INS/N 401-0765 N45506Mid Continent Aircraft Corp · Hayti, MOBuilt 1991 · S/N 502-0132 N4550NNewberg Sky Spray LLC · Hector, MNBuilt 1991 · S/N 502-0131 N4551MCady Leslie L · Rock Falls, ILBuilt 1991 · S/N 502-0133 N4552TMci Leasing LLC · Decatur, ILS/N 402-0750 N45553Racer Aviation LLC · Moorestown, NJBuilt 1991 · S/N 402-0818 N4555YDevil Dusters Inc · Artesia, NMBuilt 1991 · S/N 402-0812 N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815 N4556WVersaair Services LLC · Overland Park, KSBuilt 1991 · S/N 401-0817 N455RANorrland Partners LLC · Hillsboro, NDBuilt 2024 · S/N 802-1167 N4567SBoyle Flying Service Inc · Boyle, MSBuilt 2014 · S/N 802A-0571 N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201 N458RANorrland Partners LLC · Hillsboro, NDBuilt 2025 · S/N 802A-1212 N459RASilver Wings Flying Company LLC · Littlerock, WABuilt 2025 · S/N 802A-1243 N469LACounty Line Flying Service Inc · Coy, ARBuilt 2012 · S/N 802A-0469 N471HKSak II LLC · Miller, SDBuilt 2021 · S/N 802A-0883

Back to AD 2001-10-04 R1