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.

N9398ATraver Larry L · Sturgis, SDBuilt 1950 · S/N 7477 N9398CHolden Daniel N · Anacortes, WABuilt 1955 · S/N 31796 N9398XRegistration Pending · Chillicothe, OHRegistration pendingBuilt 1962 · S/N 18253798 N9399ABarron Aviation LLC · Perry, MOBuilt 1950 · S/N 7556 N9399CHansen Sean J · Anchorage, AKBuilt 1955 · S/N 31797 N9399MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700652 N9399XStorm Flying Service LLC · David City, NEBuilt 1962 · S/N 18253799 N939DJJaffray Management LLC · Green Cove Springs, FLBuilt 2003 · S/N 18281226 N939RLHintzsche Roger E Trustee · Dekalb, ILBuilt 1974 · S/N 21060470 N93BZMoreno Joseph L · San Diego, CABuilt 1966 · S/N 18257189 N93ETGhatan Farhad · Friday Harbor, WAS/N U20604178 N93FMAms Aviation LLC · South Bend, INBuilt 1978 · S/N 18266303 N93HPAxe Capitol Inc · Lake City, FLBuilt 1984 · S/N 21064843 N93JESibora Group LLC · Gilbert, AZBuilt 1974 · S/N 21060540 N93MBNorthwoods Air LLC · Orono, MEBuilt 1979 · S/N 18267373 N93MMChristenson Robert E · Anacortes, WABuilt 1957 · S/N 34314 N93QDurtschi James Werner · Sisters, ORBuilt 1959 · S/N 50577 N93SDRealtyaviation LLC · Key Largo, FLBuilt 2018 · S/N 18283036 N93THAir Chief LLC · Granbury, TXBuilt 1977 · S/N 18265936 N9400GMurphy James T · Nashville, TNBuilt 1970 · S/N U20601600 N9400XWilliams Dutch R · Mohave Valley, AZBuilt 1961 · S/N 21057700 N94018Northern Air Transport Inc · Mora, MNBuilt 1974 · S/N 21060483 N9401GNoble Cody Trustee · Ardmore, OKBuilt 1970 · S/N U20601601 N9402CMontgomery Robert L · Port Angeles, WABuilt 1955 · S/N 31800 N9402DH C E Leasing LLC · Cleveland, TNBuilt 2012 · S/N 18282312 N9402XSewell John · Sugar Grove, ILBuilt 1961 · S/N 21057702 N94035Husbands David · Bosque, NMBuilt 1974 · S/N 21060487 N9403CDobson Michael W · Konawa, OKBuilt 1955 · S/N 31801 N9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLBuilt 1981 · S/N 21064498 N9404CBergh Gene H · Roberts, WIFirst renewal noticeBuilt 1955 · S/N 31802 N9405CRamsower Charles M · Parma, IDBuilt 1955 · S/N 31803 N9405RJones Lance E · Duncan, OKS/N U20606853 N94077Milky Way LLC · Fresno, CABuilt 1974 · S/N 21060497 N9407CTyrrell Richard E · Central, AKBuilt 1955 · S/N 31805 N9407TBodin Logan T · Lake Charles, LAS/N 57207 N9407XDriggers Kenneth Jerry · Rialto, CABuilt 1961 · S/N 21057707 N9408HWanamaker Jeffrey Cass · Fall City, WAFirst renewal noticeBuilt 1981 · S/N 18267943 N9409TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57209 N9409XEnergy Transfer Aviation LLC · Spring, TXBuilt 1985 · S/N 18268515 N940CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282405 N940HPKansas Highway Patrol · Topeka, KSS/N 20608343 N940MAMoore Charles H · Richmond, TXBuilt 1998 · S/N 18280360 N940WSkyhawks Inc · Westminster, COBuilt 1965 · S/N 18256606 N9410MWomack David H · Rayville, LAS/N 21059310 N9410XHendrix Philip R · Corpus Christi, TXS/N 21057710 N9411XDiy Aerial LLC · Watkinsville, GABuilt 1960 · S/N 21057711 N9412EGonzalez Charles L Trustee · Huntington Beach, CABuilt 1984 · S/N 18268408 N9412MFly-N-High LLC · Riverton, WYBuilt 1970 · S/N 21059312 N9412ZHelms Stephen G · Anchorage, AKBuilt 1982 · S/N U20606473 N9413CRegistered aircraftBuilt 1955 · S/N 31811

Back to AD 84-10-01 R1