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.

N2568GKoechen Wayne L · Cooper Landing, AKBuilt 1959 · S/N 51868 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N2569KHarris Curtis M · Anchorage, AKS/N 18052991 N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569 N256MEBachelor Joseph Todd · Southside, ALS/N 18280766 N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967 N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336 N2570QGolden Thomas J · Bishop, GAS/N 18257770 N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270 N2570ZLucci Robert J · Long Lake, NYBuilt 1963 · S/N 185-0570 N2571GGolf Air LLC · Anchorage, AKBuilt 1959 · S/N 51871 N25722Mitchell Brian J · Boise, IDBuilt 1963 · S/N 18051274 N2572GMorgan Nathan · Boise, IDBuilt 1959 · S/N 51872 N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272 N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332 N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072 N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995 N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173 N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073 N2574RChauvin Junius · Franklin, LAS/N 18258274 N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875 N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997 N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075 N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776 N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277 N2577ZMaynard Christopher J · Anchorage, AKBuilt 1964 · S/N 185-0577 N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879 N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000 N257ABMountain Peak Financial Inc · Palm Desert, CABuilt 1998 · S/N 18280259 N257AEBhm Kcak LLC · Akron, OHBuilt 1997 · S/N 18280019 N257CESimonelli Aviation LLC · Fort Myers, FLBuilt 2024 · S/N 18283257 N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090 N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548 N257RRegistered aircraftBuilt 1957 · S/N 34411 N257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781 N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880 N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333 N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002 N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003 N2582Q82q LLC · Glenwood, MDS/N 18257782 N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282 N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883 N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283 N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083 N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005 N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885 N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285 N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786 N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288 N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588

Back to AD 84-10-01 R1