Registered aircraft · 20,483

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.

N4640KLarson Family Farms LLC · Haxtun, COBuilt 1975 · S/N 18263713 N4641BKey James M · Hermiston, ORBuilt 1955 · S/N 31539 N4642BRegister Edmond A · Tyler, TXBuilt 1955 · S/N 31540 N4642UHolt John William · Tucson, AZFirst renewal noticeBuilt 1964 · S/N 18051342 N4643BAnderson Charles D · Fairbanks, AKBuilt 1955 · S/N 31541 N4644ALee Lauren M · West Greenwich, RIBuilt 1956 · S/N 32241 N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244 N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797 N4645BJacobs Lydia A · Lincoln, MES/N 31543 N4645FScruggs Ken R · Galloway, OHS/N P206-0245 N4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 18263647 N4646ANorth Sixty Taildraggers LLC · Port Ludlow, WABuilt 1956 · S/N 32243 N4646BBravo 300 LLC · Coweta, OKS/N 31544 N4646HMilton Djana · Lakewood, WABuilt 1981 · S/N 18267847 N4646KPloense Justin M · Big Bear City, CAS/N 18263648 N4647AAuch Leo R · Scio, ORBuilt 1956 · S/N 32244 N4648CMadhvani Sanjay J · Tucson, AZBuilt 1979 · S/N 21063583 N4648ERandall John Kelly · Fremont, OHBuilt 1982 · S/N 18268254 N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248 N4649BNicholson Stephen G · Bayfield, COBuilt 1955 · S/N 31547 N4649TNew York Aircam Corp · Woodbury, NYBuilt 1981 · S/N R18201724 N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028 N464CSBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 18283164 N464FVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283092 N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744 N464HExecutive Flight Training LLC · Beaufort, SCBuilt 2020 · S/N 18283120 N464JTextron Aviation Inc · Wichita, KSS/N 18283360 N464KKing Aaron M · Knoxville, TNBuilt 1997 · S/N 18280039 N464LC P Holdings LLC · Watertown, SDBuilt 2018 · S/N 18283060 N464MASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 18280822 N464RWilson Aaron I · Fairmont, WVS/N 18260464 N464TASwny Aero LLC · Cambridge, MABuilt 2016 · S/N 18282450 N464WNimbus Adventures LLC · Morganton, NCBuilt 2022 · S/N 18283212 N4650BByrne Robert R · Cameron Park, CABuilt 1955 · S/N 31548 N4651NSuemac Farms LLC · Crawfordsville, ARS/N 18267284 N4651TUnited Indian Missions Inc DBA · Tucson, AZBuilt 1979 · S/N U20605255 N46524Barry Mark K · Larimore, NDBuilt 1974 · S/N 18052424 N4652TSilver Wings Aviation LLC · Kalispell, MTS/N R18201725 N46535Rugged View Aviation LLC · Condon, MTBuilt 1974 · S/N 18052425 N4653AKuzina Ronald E · Wasilla, AKBuilt 1956 · S/N 32250 N4653Q53 Quebec LLC · El Dorado, CABuilt 1972 · S/N 21059553 N4654AZerbinos Nicholas J · Anchorage, AKBuilt 1956 · S/N 32251 N4654KHoffman Matthew A · Baltimore, MDBuilt 1975 · S/N 18263656 N4654QStapleton Mark Christopher · Vestavia Hills, ALBuilt 1972 · S/N 21059554 N4655AMasten Kirk E · Roanoke, INBuilt 1956 · S/N 32252 N4655EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268255 N46563Stephen Iain D · Anchorage, AKBuilt 1974 · S/N 18052427 N4656FCrowley Thomas Bannon III · Tigard, ORBuilt 1966 · S/N P206-0256 N4656SEtheridge Caleb · Cedartown, GAS/N R18201368 N4657BBeam Gregory E · Anchorage, AKBuilt 1955 · S/N 31555

Back to AD 84-10-01 R1