Registered aircraft · 2,376

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N977BCPilots Flying School LLC · Englishtown, NJBuilt 1976 · S/N 28R-7635326 N9789CLinares Carlos W · Concord, CABuilt 1978 · S/N 28R-7837221 N97UAManufacturing Services And Solutions LLC · Lake Villa, ILBuilt 1978 · S/N 28R7837163 N9809KS&S Investment Solutions LLC · Lakeland, TNBuilt 1977 · S/N 28R-7837039 N980ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 2844051 N9817KN9817k LLC · Fredricksburg, VABuilt 1977 · S/N 28R-7837040 N9874KReintjes Byron · Fresno, CABuilt 1977 · S/N 28R-7803072 N987DCLewis Michael · Anaheim, CABuilt 1980 · S/N 28R8031103 N987EGPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1972 · S/N 28R-7335027 N987TDRegistered aircraftBuilt 1974 · S/N 28R-7535075 N9890KWilliams Robert · Dawsonville, GABuilt 1977 · S/N 28R-7837046 N9893KReuter Daniel · Cupertino, CABuilt 1978 · S/N 28R-7803079 N98JGDistrict Board Of Trustees Miami Dade College Fl · Miami, FLBuilt 1969 · S/N 28R-35117 N98UAKnox Kevin J · Verdi, NVBuilt 1980 · S/N 28R-8018035 N991VTCrosswinds Flying Club Inc · Bloomington, ILBuilt 1978 · S/N 28R-7837267 N9946CTheodorou Evangelos A · Bakersfield, CAS/N 28R-7931300 N994BCEast Coast Flyers LLC · Rockville, MDBuilt 1970 · S/N 28R-7135036 N999ADAllison Aviation LLC · Pueblo, COS/N 28R-7235117 N999RJReschke William E · San Diego, CABuilt 1969 · S/N 28R-35169 N999VFCrawford David B · Warren, OHBuilt 1971 · S/N 28R-7135143 N99DCCook Adam Richard · Lincoln, CABuilt 1977 · S/N 28R-7803109 N99R206aa LLC · Saint John, INBuilt 1969 · S/N 28R-35160 N9FNMyf Holdings LLC · San Diego, CABuilt 1978 · S/N 28R-7837153 N9FSEagle Ey5 LLC · Ashland, MOBuilt 1977 · S/N 28R7703378 N9PMNdlebe Isabella L · Okemos, MIBuilt 1977 · S/N 28R-7837115 N9PNMid-Atlantic Aircraft LLC · Stewartstown, PABuilt 1979 · S/N 28R-8018029

Back to AD 82-06-11 R1