Registered aircraft · 19

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:69-05-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:69-05-06') 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:69-05-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:69-05-06')
  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:69-05-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:69-05-06')
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.

N102KWabash Valley Soaring Association Inc · Lawrenceville, ILBuilt 1967 · S/N 4108 N116DSStevenson Malcolm D Jr · Cedar Crest, NMBuilt 1985 · S/N 6025 N13233Ag Leasing LLC · Wilmington, DES/N 4004 N1342Pfeiffer Neal J · Wichita, KSBuilt 1967 · S/N 4135 N166EChesser Richard S · Aiken, SCBuilt 1968 · S/N 4207 N1771RLsk Aviation Corp · Wilmington, DES/N 4096 N2634PWagenknecht Harald H · Ruther Glen, VABuilt 1966 · S/N 4050 N3075Gradwell Dean H · Jacksonville, ORBuilt 1965 · S/N 4024 N3083Leonard Steven E · Wichita, KSBuilt 1968 · S/N 4161 N3176Schuur David L · Flat Rock, ILBuilt 1968 · S/N 4176 N335SEConnelly William E · Omaha, NEBuilt 1968 · S/N 4229 N43JHohanshelt Laura S · Minneapolis, MNBuilt 1970 · S/N 4345 N4784SPort Townsend Aero Museum · Port Townsend, WABuilt 1965 · S/N 4010 N53RAWichita Soaring Assoc · Wichita, KSBuilt 1970 · S/N 4343 N588MPedreiro Sergio · Greenwich, CTBuilt 1966 · S/N 4049 N59256Seymour David E · Evergreen, COBuilt 1966 · S/N 4057 N66KEStone Richard E · Lebanon, ILBuilt 1968 · S/N 4205 N7714Kolberg Rocky S · Kelso, WABuilt 1967 · S/N 4131 N99DWU S Southwest Soaring Museum Inc · Moriarty, NMS/N 4081

Back to AD 69-05-06