Registered aircraft · 23

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-22-07') 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-22-07') 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-22-07')
    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-22-07')
  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-22-07')
  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-22-07')
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.

N101CLBritronix Inc · Las Vegas, NVBuilt 1973 · S/N 1061 N150SFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 1584 N16KHBella Charles · El Paso, TXS/N 1456 N2FWComanche Maverick Air LLC · Houston, TXBuilt 1977 · S/N 1363 N340SMValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 1509 N341ASInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 1972 · S/N 1042 N341DTInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 1110 N341GGEastern Stearman Inc Trustee · Leesburg, VABuilt 1974 · S/N 1181 N341GHJbp Aviation LLC · Henderson, NVS/N 1017 N341GLSouth America Tactical & Airborne Consulting Corp · Wilmington, DES/N 1413 N341HHRegistration Pending · Azle, TXRegistration pendingBuilt 1972 · S/N 1099 N341LCenterline Holdings Inc · San Marcos, CAS/N 1263 N341WWInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 1206 N341XRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 1035 N341ZLOsborne Thomas · Bay City, ORBuilt 1975 · S/N 1262 N37UPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 1224 N505HASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 1022 N505KHBella Charles · El Paso, TXBuilt 1975 · S/N 1239 N505NMClassic Rotors Museum · Ramona, CABuilt 1977 · S/N 1408 N686DTCalifornia Air Center · Tarzana, CABuilt 1974 · S/N 1200 N700SHInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 1154 N71FRNivlem Farm Management LLC · Kalispell, MTBuilt 1975 · S/N 1274 N901BInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 1410

Back to AD 75-22-07