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.

N3205UBanducci Debra L Trustee · Bakersfield, CABuilt 1963 · S/N 18254605 N3206DDenny Michelle L · Chugiak, AKBuilt 1955 · S/N 32004 N3206SHall David J · Red Bluff, CABuilt 1964 · S/N 18255706 N3207SSouthern Star Aviation LLC · El Campo, TXBuilt 1964 · S/N 18255707 N3207UTaf Aerial Services LLC · Beeville, TXBuilt 1963 · S/N 18254607 N3208SZirul James V · Kenai, AKBuilt 1964 · S/N 18255708 N3208UDiller Larry K · Fairview, MIBuilt 1963 · S/N 18254608 N3208YHamilton Triple C Farms · Ririe, IDFirst renewal noticeBuilt 1962 · S/N 18254208 N320RCEastern Properties LLC · Burlington, NJBuilt 2004 · S/N 18281352 N3210SGore Range Aviators LLC · Kremmling, COBuilt 1964 · S/N 18255710 N3210UHaas Todd · Pecatonica, ILBuilt 1963 · S/N 18254610 N3210YBergren William · Des Moines, IABuilt 1962 · S/N 18254210 N3211DNielson Donald L · Independence, ORBuilt 1955 · S/N 32009 N3211SNoble Tom R · Winnsboro, TXBuilt 1964 · S/N 18255711 N3211YFour M Properties LLC · Prague, OKBuilt 1962 · S/N 18254211 N3213SRosengrants Matthew R · Walsh, COBuilt 1964 · S/N 18255713 N3213YFletcher Jerry D · Yukon, OKBuilt 1962 · S/N 18254213 N3214UBibus Michael A · Austin, MNBuilt 1963 · S/N 18254614 N3217SGrotbeck Christopher L · Albuquerque, NMBuilt 1964 · S/N 18255717 N3217YBrowne Robin P · Dallas, TXBuilt 1962 · S/N 18254217 N3218DWright James Cope · Round Rock, TXBuilt 1955 · S/N 32016 N3218URadford Tara Lynn · Elmira Heights, NYBuilt 1963 · S/N 18254618 N3218YCollins Marcus E Jr · Camilla, GABuilt 1962 · S/N 18254218 N3219SYogodzinkski Steve M · Amberson, PAS/N 18255719 N321AYCameron Kari L · Ashland, ORBuilt 1973 · S/N 18261756 N321BPCenturion Air Inc · Ridgewood, NJS/N 21063986 N321BSBrown Gregory N Trustee · Flagstaff, AZBuilt 1978 · S/N 18266765 N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061 N321DGAdkison Edy P · Riverside, CABuilt 1969 · S/N 21059201 N321DKTwi Air LLC · Picayune, MSBuilt 1998 · S/N 18280311 N321EEVermont Skydiving Adventures Inc · Addison, VTBuilt 1956 · S/N 33582 N321GW321gw LLC · Chico, CABuilt 1998 · S/N 18280209 N321HWVan Andel Lambert J Jr · Coopersville, MIBuilt 1998 · S/N 18280264 N321KKPanoche Aviation Co LLC · Fresno, CABuilt 1979 · S/N 18267488 N321LGLaughing Gull Aviation Inc · Fort Lauderdale, FLBuilt 1978 · S/N 21062769 N321PCStene Aviation Inc · Polson, MTS/N 21062813 N321PPMathews Aviation LLC · Marysville, CABuilt 1977 · S/N 18265834 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N321RBMessmore Micheal Henry · Toledo, WABuilt 1976 · S/N 18052677 N321RZRieger Joseph M · Ashland, ORBuilt 1979 · S/N 18267199 N321WHBonanza Equipment Leasing LLC · Missoula, MTBuilt 1979 · S/N 18266927 N3220YTanner Fred E · Westville, FLS/N 18254327 N3221SPropwash LLC · Mesquite, NVBuilt 1964 · S/N 18255721 N3221YRegistration Pending · Brea, CARegistration pendingS/N 18254221 N3222DBeggs Patrick C · Salem, ORBuilt 1955 · S/N 32020 N3222YCreighton Andrew M · Lebanon, TNBuilt 1962 · S/N 18254222 N3223DCliff Robinson Real Estate Corp · Madison, INBuilt 1955 · S/N 32021 N3223UPerry Joseph R · Portland, ORBuilt 1963 · S/N 18254623 N3224CHassebrock John M · Colorado Springs, COBuilt 1978 · S/N R18200257 N3224DE W Aircraft LLC · Manhattan, MTBuilt 1954 · S/N 32022

Back to AD 84-10-01 R1