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.

N8247ZBeam Troy A Trustee · Shippensburg, PABuilt 1963 · S/N 205-0247 N82488Simpson Patrick E · Ketchum, IDBuilt 1964 · S/N 18255745 N8249GComerford John D Trustee · Saint Louis, MOBuilt 1974 · S/N 18263356 N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039 N8249VSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18051751 N824AJWilliams John R Trustee · Trophy Club, TXBuilt 2012 · S/N 18282315 N824BABarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 18266788 N824FFly Well Flying Club Inc · Roseville, MNBuilt 1977 · S/N R18200022 N824HAFeingersh Harry · Houston, TXBuilt 2006 · S/N 18281824 N824NMMastrangelo Barry D · Cape May Ch, NJBuilt 2001 · S/N 18280972 N824WPPhillips Wayne A Trustee · Cameron Park, CABuilt 1973 · S/N 18262152 N8251ZGarner Charlotte Trustee · Sun Lakes, AZBuilt 1963 · S/N 205-0251 N8252MApplied Olap Inc · Huntsville, ALBuilt 1969 · S/N 21059252 N8253MHudak Organization LLC · Cedar Grove, NJBuilt 1969 · S/N 21059253 N8253QTogo Aviation Services LLC · Palmer, AKBuilt 1976 · S/N U20603249 N8254QTogo Aviation Services LLC · Palmer, AKBuilt 1970 · S/N U2061479 N8255QKavik Aviation Services LLC · Palmer, AKBuilt 1975 · S/N U20603116 N8255ZSonoma County Fliers LLC · Petaluma, CABuilt 1963 · S/N 205-0255 N8256QRegistered aircraftBuilt 1975 · S/N U20603117 N8256ZRapozo Martin · Tarpon Springs, FLBuilt 1964 · S/N 205-0256 N8257ZFunanich Jon J Trustee · Fairfield, CABuilt 1963 · S/N 205-0257 N8259ZZulu Hay LLC · Mesa, WABuilt 1963 · S/N 205-0259 N825NGPantelaras Nikiforos N · Riviera Beach, FLBuilt 1959 · S/N 52183 N825SQuamme Eric P · Peachtree City, GAS/N 18255428 N825SWFlying Griffon Aviation LLC · Traverse City, MIBuilt 2021 · S/N 18283139 N8260MCloud Dancer LLC · El Paso, TXS/N 21062040 N8261MZaller Anthony J · Phoenix, AZBuilt 1970 · S/N 21059261 N8261ZWardlay Farms And Ranches · Grandview, TXBuilt 1963 · S/N 2050261 N8262MThrasher Dennis L · Tucson, AZBuilt 1970 · S/N 21059262 N8262VBoyd Russell · Boerne, TXBuilt 1974 · S/N 18262574 N8263GFitzpatrick Dennis B · Mccall, IDBuilt 1977 · S/N U20603784 N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125 N8266MCenturion Aviation LLC · Groveland, FLBuilt 1970 · S/N 21059266 N82687Boniek Martin J · Mccarthy, AKS/N U20603424 N8268MGilbert Brad E · Heron, MTBuilt 1976 · S/N 18264577 N8268ZButler Aviation Group LLC · Tonopah, AZBuilt 1963 · S/N 205-0268 N8269GReuven Moshe · Marlborough, MABuilt 1974 · S/N 18263359 N826CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281264 N826KJHlm Aircraft LLC · Marion, MSBuilt 1968 · S/N 18259041 N826TRRcc Resource Commerical Inc · Dallas, TXBuilt 2010 · S/N 18282241 N826WSaucedo Arnoldo · Midland, TXS/N 18256526 N8271MBoyd David R · San Jose, CAS/N 21062041 N8273PA-Z Aviation LLC · Bay City, MIBuilt 1967 · S/N 18051901 N8273QHelmericks Isaac J · Palmer, AKBuilt 1976 · S/N U20603134 N8273ZGssl Inc DBA · Tillamook, ORBuilt 1963 · S/N 2050273 N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135 N8275MValiair Limited Company Trustee · Casper, WYBuilt 1970 · S/N 21059275 N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136 N8276YVrem Kevin · Anchorage, AKBuilt 1977 · S/N 18052778 N8277MBlalock Paul T · Longview, TXBuilt 1970 · S/N 21059277

Back to AD 84-10-01 R1