Registered aircraft · 67

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

N690TGNeptune Aviation Services Inc · Missoula, MTBuilt 1976 · S/N 11319 N690TRKolob Canyons Air Services Inc · Wilmington, DEBuilt 1972 · S/N 11034 N690WS69 Whiskey LLC · Nezperce, IDBuilt 1974 · S/N 11194 N699SBMeginnis Thomas O · Omaha, NEBuilt 1976 · S/N 11280 N750RGHmcs LLC · Charlotte, NCS/N 12044 N75UFive Uniform LLC · Ooltewah, TNS/N 11218 N76ECAltair Aircraft LLC · Gainesville, FLS/N 11208 N76WAFlying A Flight Service LLC · Safford, AZBuilt 1976 · S/N 11342 N823SBPia Avcenter LLC · Peoria, ILBuilt 1975 · S/N 11304 N848CECourtney Aviaton LLC · Columbia, CABuilt 1975 · S/N 11303 N892WATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 11273 N8PQElkhorn Aviation Inc · Baker City, ORBuilt 1975 · S/N 11243 N90ATKolob Canyons Air Services Inc · Wilmington, DEBuilt 1975 · S/N 11272 N911KCCounty Of Kern · Bakersfield, CABuilt 1975 · S/N 11300 N95JMRemington Aerospace LLC · Chandler, AZBuilt 1975 · S/N 11289 N95LFNeptune Aviation Services Inc · Missoula, MTBuilt 1975 · S/N 11290 N98PJPia Avcenter LLC · Peoria, ILBuilt 1976 · S/N 11320

Back to AD 75-19-01