Registered aircraft · 17

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-16-01-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:80-16-01-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:80-16-01-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:80-16-01-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:80-16-01-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:80-16-01-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.

N105GKBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N S-458 N124EHJbp Aviation LLC · Henderson, NVS/N S559 N131AEAtwood Aviation LLC · Pickerington, OHBuilt 1988 · S/N S787 N13TZAerospace Trust Management LLC Trustee · Wilmington, DES/N S550 N156HMSky West Aviation Inc Trustee · Albuquerque, NMS/N S-608 N327MHMaritime Helicopters Inc · Homer, AKBuilt 1989 · S/N S813 N3538TSan Juan Aviation LLC · Wilmington, DERegistration expired, pending cancellationBuilt 1977 · S/N S-350 N525ZDg&R LLC · Murray, UTBuilt 1977 · S/N S-349 N549VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N S-549 N554RPTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 1973 · S/N S-111 N5BGLinscott Jeffrey Rodman · Boring, ORBuilt 1988 · S/N S799 N633MBCenterline Holdings Inc · Camden, DEBuilt 1986 · S/N S-750 N65DACenter For Vertical Studies LLC · Sheridan, WYBuilt 1991 · S/N S-854 N7062XPatriot Aviation Inc · Greenville, DES/N S-793 N8199JPeace And Freedom Helicopters LLC · Wilmington, DES/N S-826 N911AKMse Air Group Inc · Ciales, PRS/N S-63 N911ANAlaska Tactical Aviation LLC · Palmer, AKBuilt 1974 · S/N S-156

Back to AD 80-16-01 R1