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

N113JPJuliette Papa Leasing LLC · Kalispell, MTBuilt 1989 · S/N 2265 N132TVU S Helicopters Inc · Marshville, NCBuilt 1982 · S/N 1636 N151ADAtlantic Coast Maintenance · Palm Coast, FLS/N 1173 N212CMAerospace Trust Management LLC Trustee · Wilmington, DES/N 2232 N214STBank Of Utah Trustee · Salt Lake City, UTS/N 2141 N275BPCity Of Burbank · Burbank, CAS/N 1930 N350MALabutte Air Inc · Flint, MIBuilt 1986 · S/N 1882 N350NTNorth Texas Helicopters Inc · Newark, TXBuilt 1982 · S/N 1512 N350UKInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 1244 N3604TRotorcraft Support Inc · Fillmore, CABuilt 1979 · S/N 1158 N36TVUS Helicopters Inc · Marshville, NCS/N 1858 N394NSNorthstar Trekking · Juneau, AKBuilt 1979 · S/N 1066 N48BGazelle LLC · Missoula, MTS/N 1481 N5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 1836 N613CMEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1632 N614SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1534 N792LFGulf State Aviation LLC · Tomball, TXBuilt 1978 · S/N 1035 N888HVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 2386 N888TVU S Helicopters Inc · Marshville, NCBuilt 1978 · S/N 2007 N909KPRiccochet LLC · Okeechobee, FLS/N 1472 N929WBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 2335 N955HDTurbolyft USA Corp · Pitt Meadows BcNon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 1596 N963ESFast Helicopters Inc Trustee · Wilmington, DEBuilt 1979 · S/N 1089

Back to AD 80-15-05