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.

N9023XBlue Skies Matter LLC · Spokane, WABuilt 1961 · S/N 18253423 N9024CBaker Lewis E Jr Trustee · Anchorage, AKBuilt 1954 · S/N 31072 N9024GJessop Jacob N · Cedar City, UTBuilt 1971 · S/N 18260564 N9024MDamianov Venko · Dallas, TXBuilt 1970 · S/N 18052124 N9025GN9025g LLC · Indianapolis, INBuilt 1971 · S/N 18260565 N9026GTekoa Skylane Club · Chattaroy, WAS/N 18260566 N9026MGlenn Stephen B · Texarkana, TXBuilt 1977 · S/N 21062051 N9027GCessna Flyers LLC · Spartanburg, SCBuilt 1971 · S/N 18260567 N9027TSwanson Roy D · Douglas, AZBuilt 1960 · S/N 52927 N9027XDelauder Patrick J · Terra Alta, WVBuilt 1961 · S/N 18253427 N9028CEvans Johnny D I · Wasilla, AKBuilt 1954 · S/N 31076 N9028MMumford Charles E Trustee · Big Lake, AKBuilt 1970 · S/N 18052128 N9028TFultz William L · Buckhannon, WVS/N 52928 N9028XGold Coast Skydivers Louisiana Adventures LLC · Slidell, LABuilt 1961 · S/N 18253428 N9029MSturgeon Ronald A · Anchorage, AKBuilt 1970 · S/N 18052129 N9029XWichmann David · Park City, UTBuilt 1961 · S/N 18253429 N902APPollard Aircraft Sales Inc · Fort Worth, TXBuilt 1998 · S/N 18280306 N9030TClark Joseph J · Fairbanks, AKBuilt 1960 · S/N 52930 N9031UBlue Sky Aero Club Inc · Escondido, CABuilt 1977 · S/N 18265445 N90322State Of Alaska Department Of Public Safety · Anchorage, AKS/N 20608323 N9032CGoodman Kim J · Burnsville, NCBuilt 1978 · S/N R18200377 N9032MWillke Theodore Lawrence II · Tacoma, WAS/N 21062052 N9032XWalters Douglas R · Sunbury, OHBuilt 1961 · S/N 18253432 N9033CPrice Tom Jr · Baker City, ORBuilt 1954 · S/N 31081 N9033GHillside Air Service LLC · Roanoke, INS/N 18260573 N9033MBasinger Robert C · Freedom, PABuilt 1976 · S/N 18264652 N9034CGrizzly Air Service Inc · Paris, TXBuilt 1954 · S/N 31082 N9034GDanielle K Heckman · Crystal River, FLBuilt 1971 · S/N 18260574 N9034XCunningham Patrick J · Council Bluffs, IABuilt 1961 · S/N 18253434 N9035GRd Smith LLC · Rexburg, IDBuilt 1971 · S/N 18260575 N9036BVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N 18282258 N9036MChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062053 N9036XNiemeyer Henry · Eagle River, AKS/N 18253436 N9037MLevin Austin T Trustee · Prairie Du Sac, WIBuilt 1970 · S/N 18052137 N9037XFornasier Manuel Jr · Westcliffe, COBuilt 1961 · S/N 18253437 N9038CMackay Scott · Spokane Valley, WABuilt 1954 · S/N 31086 N90391Meyer Florence Trustee · Billings, MTBuilt 2010 · S/N 18282259 N9039CDouble O Seven Limited Co · Carefree, AZBuilt 1978 · S/N R18200378 N9039TMetal Bird LLC · West Jordan, UTBuilt 1960 · S/N 52939 N9039XAhrens Videll A · Tintah, MNBuilt 1961 · S/N 18253439 N9040CTexas Skyways Inc · Boerne, TXBuilt 1979 · S/N R18200379 N9040XAcme Air Venture Inc · Bristol, WIS/N 18253440 N9042TCase Rod E · Gold Hill, ORBuilt 1960 · S/N 52942 N9043CHemphill Holdings LLC · Hemphill, TXBuilt 1954 · S/N 31091 N9043XKruger Bruce W · Gustavus, AKS/N 18253443 N9044MOlsen Dale B · Wasilla, AKBuilt 1970 · S/N 18052144 N9045GSkyview LLC · Omaha, NEBuilt 1971 · S/N 18260585 N9045MCunningham Bill · Tulsa, OKBuilt 1976 · S/N 18264655 N9046CSherwood David R · Porterville, CABuilt 1955 · S/N 31094 N9046FCenturion Aviation LLC · Lewes, DEBuilt 1979 · S/N 210-63014

Back to AD 84-10-01 R1