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.

N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678 N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578 N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378 N2479CTo The Wind LLC · Salmon, IDBuilt 1954 · S/N 30779 N2479QPriest David E · Caldwell, IDBuilt 1966 · S/N 18257679 N2479XKruse Interests LLC · League City, TXS/N 18256379 N247CBDream Machine Leasing LLC · Glenbrook, NVBuilt 1981 · S/N U20606194 N247FMansfield Heliflight Inc · Milton, VTBuilt 2005 · S/N 20608247 N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872 N247SARoss Branta Enterprises · Boise, IDBuilt 2003 · S/N 20608199 N2480GGassaway Mitchell E · Carrollton, TXBuilt 1959 · S/N 51780 N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2481CPippert Jim · Dysart, IABuilt 1954 · S/N 30781 N2481GEaster Brett D · Enumclaw, WABuilt 1959 · S/N 51781 N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581 N2481UWilliams Jeremy · Searsport, MES/N U20602380 N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782 N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682 N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685 N2483GLenox Mark W · Idaho Falls, IDS/N 51783 N2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683 N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583 N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784 N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686 N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785 N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685 N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786 N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786 N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586 N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386 N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787 N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587 N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344 N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788 N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588 N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388 N2489CRegistered aircraftBuilt 1954 · S/N 30789 N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789 N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389 N248HSLitchfield Lantz · Las Vegas, NVBuilt 1978 · S/N 21062726 N248JWN248jw LLC · Sammamish, WABuilt 2023 · S/N 18283211 N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590 N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390 N2491GShowah Christopher Douglas · Indianola, MSS/N 51791 N2491QLong Daniel · Stevenson, ALBuilt 1966 · S/N 18257691 N2491RDaly John M · Fort Worth, TXBuilt 1964 · S/N 18255591 N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391 N2492CTjossem Martin O · Paullina, IABuilt 1954 · S/N 30792 N2492SSierra Hotel Aircraft LLC · Wilmington, DEBuilt 1976 · S/N 21061302 N2493CBallard Bradley J · Youngsville, NCBuilt 1954 · S/N 30793

Back to AD 84-10-01 R1