Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911 N611SAAda Forestry Division · Malvern, ARBuilt 1976 · S/N 18265295 N611SFWood Automotive Inc · Cropwell, ALBuilt 2023 · S/N 18283224 N611TMWest Michigan Skybirds Inc · Battle Creek, MIBuilt 1978 · S/N 21063037 N611WJDiamondtooling Inc · Wilmington, DEFirst renewal noticeBuilt 1975 · S/N 18264334 N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134 N6120BSmith Richard D II · Luthersville, GAS/N 34120 N6120SLash Gary L · Round Rock, TXBuilt 1980 · S/N R18201618 N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021 N6122BBendickson Tim T · Priest Lake, IDBuilt 1957 · S/N 34122 N6122NBernhard Andreas P F · Palm City, FLBuilt 1980 · S/N 18267792 N6122SBusiness Jet Managers Inc · Canton, MIBuilt 1980 · S/N R18201619 N6123BNeal Aircraft Inc · Slaton, TXBuilt 1957 · S/N 34123 N6124BShullanberger Ranch LLC · Lakeview, ORS/N 34124 N6124TBanjo Ben Aviation LLC · Kilgore, TXS/N R18201911 N6124ZMulchatna Air Taxi LLC · Dillingham, AKS/N U20606150 N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025 N6125PThomas Roger · Hudson, OHBuilt 2004 · S/N 18281387 N61266Osborn Douglas · Madison, WIS/N 18052779 N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026 N6126RKelley Kal · Colville, WAS/N T210-0026 N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260 N61273Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602067 N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604 N61276Sonnys Aviation Inc · Miami, FLFirst renewal noticeBuilt 1973 · S/N U20602069 N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027 N6127RPhillips Bill · Galt, CABuilt 1965 · S/N T210-0027 N6128NJones Charles C · Mccall, IDBuilt 1980 · S/N 18267794 N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028 N6128TStone Mark · Scotts Valley, CABuilt 1982 · S/N R18201912 N6129RIncline Engineering And Consulting LLC · Ovalo, TXBuilt 1965 · S/N T210-0029 N612ADCurless Harley J · Havana, ILBuilt 1974 · S/N 182-62855 N612BKKqm Aviation · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 20608325 N612DPCarlson Glenn Alan · Byron Center, MIBuilt 2007 · S/N 18281953 N612ESHouston Jason S · Shelton, WABuilt 1973 · S/N 18262270 N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651 N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356 N6130BFandango Aviation LLC · Lake Elsinore, CABuilt 1956 · S/N 34130 N6130CMay And Carter Oil Co · Jackson, GABuilt 1979 · S/N 21063808 N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030 N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030 N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508 N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031 N6131RAir LLC · Salem, ORS/N T210-0031 N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037 N6137TDurnin Timothy K · Lansing, ILS/N R18201917 N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038 N61398Ali Rizwan Rajab · Richmond, TXBuilt 2008 · S/N 18282066 N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909 N613AKNorman Scott E · Anchorage, AKBuilt 1976 · S/N 18265221

Back to AD 84-10-01 R1