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.

N9978BReal Brian M · Anchorage, AKBuilt 1957 · S/N 34378 N9978ELagasse Robert · Wolcott, CTBuilt 1985 · S/N 18268478 N9978HBrumette Aviation LLC · Vidalia, GABuilt 1982 · S/N 18268158 N9978NFulwiler Air LLC · Green Bay, WIBuilt 1975 · S/N 18052633 N9978XLyons Jeffery E · Carrollton, GABuilt 1961 · S/N 185-0178 N9979B79bravo Leasing LLC · Lincoln, DEBuilt 1957 · S/N 34379 N9979CVan Lehn Sethany A · Frederick, MDBuilt 1978 · S/N R18200495 N9979EFitzgerald Brett · Wellsville, UTBuilt 1975 · S/N 18264039 N9979GSteinke Matthew R · Gibson, IABuilt 1971 · S/N 18800779 N9979NAvtech Global LLC · Renton, WABuilt 1975 · S/N 18052634 N9979TRoth Ellen C · Blakely Island, WABuilt 1960 · S/N 18253079 N9979XGeorge Anthony L · Billings, MTBuilt 1961 · S/N 185-0179 N997AKLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N 20700019 N997CHHolly Ridge Planting · Indianola, MSBuilt 1986 · S/N T21064997 N997CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281997 N997GWWoodward Mark J · Bellingham, WABuilt 2001 · S/N 18280997 N997JBBrannan Brendon Kyle · Gardnerville, NVBuilt 1982 · S/N 18268276 N997PCHunter Marty Paul · Christine, TXFirst renewal noticeS/N 18267241 N997RRegistered aircraftBuilt 1974 · S/N 21060386 N997TXPeso Consulting LLC · Lexington, TXS/N 182-54369 N9980BBudenbender Philip W · Weatherford, TXBuilt 1957 · S/N 34380 N9980ERapid Flyers LLC · Zionsville, INBuilt 1975 · S/N 18264040 N9981NGagnon Matthew I · Fairbanks, AKS/N U20603745 N9982TAero Club Albatross · Blairstown, NJBuilt 1960 · S/N 18253082 N9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1982 · S/N 21064659 N9983BMartyn Michael L · Ridgecrest, CABuilt 1957 · S/N 34383 N9983HVisual Group LLC · Ringgold, GABuilt 1982 · S/N 18268161 N9983MTate Clint · Boise, IDBuilt 1978 · S/N U20604632 N9983RHellmann Andrew P · Newark Valley, NYBuilt 1986 · S/N U20607011 N9983TPara-Plane Aviation Inc · Thomasboro, ILBuilt 1960 · S/N 18253083 N9984CTucker Harry B · Lexington, NCBuilt 1978 · S/N R18200496 N9984EVelasco Timoteo W · South Jordan, UTBuilt 1975 · S/N 18264044 N9984TOhman Mikael A · Watonga, OKS/N 18253084 N9985NJakab Stephen F · Wasilla, AKBuilt 1975 · S/N 18052640 N9986HKirkman Todd A · Chetek, WIS/N 18268163 N9986MLogan Timothy R · Valley City, NDS/N U20604635 N9986TSkylane Ventures LLC · Keizer, ORBuilt 1960 · S/N 18253086 N9987HRoger Roger Aviation LLC · Delaware, OHBuilt 1982 · S/N 18268164 N9988NBackcountry Air LLC · Wilmington, DES/N 18052643 N9988XBenavides Antonio · Anchorage, AKBuilt 1961 · S/N 1850188 N9989ET Craft Aero Club Inc · Nampa, IDBuilt 1975 · S/N 18264049 N9989TGreat Basin Aviation LLC · Eagle River, AKBuilt 1961 · S/N 18253089 N9990EN9990e LLC · Alva, FLBuilt 1975 · S/N 18264050 N9991NTin Cup Aviation LLC · Frostproof, FLBuilt 1975 · S/N 18052646 N9991TChupp Family Trust LLC · Kalispell, MTS/N 18253091 N9991YArwlb Aviation LLC · Spokane, WABuilt 1982 · S/N 210-64661 N9992BAirco International LLC · Arlington, WABuilt 1957 · S/N 34392 N9992EWoods Charles D · Huffman, TXBuilt 1975 · S/N 18264052 N9992GDaneker Adin · Kalispell, MTBuilt 1974 · S/N 18263451 N9992NHanson Lavon T · Saint Ignatius, MTS/N U20603749

Back to AD 84-10-01 R1