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

N177AFMcgee Aviation LLC · Yorktown, VABuilt 1984 · S/N 60-8423022 N201WFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1984 · S/N 608423010 N529RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1984 · S/N 60-8423004 N626NPValli Aviation LLC · Tallahassee, FLS/N 60-8423014 N700DXPickett Herbert Timothy · Flagstaff, AZS/N 60-8423013 N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012 N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007 N701HBBlaire William C · Rch Palos Vrd, CABuilt 1984 · S/N 608423015 N702PGOn Three Angels Wings LLC · Melbourne, FLBuilt 1984 · S/N 60-8423009 N702RJStites Holdings LLC · Seattle, WAS/N 60-8423011 N707JPSierra Hotel Inc · Van Buren, ARS/N 60-8423018 N711TLBarne George H · Lexington, KYBuilt 1984 · S/N 608423017 N7988HTc Loox Consultants LLC · Washington, DCBuilt 1984 · S/N 60-8423021 N889ACKdx Air Ventures LLC · Naples, FLS/N 60-8423024 N910ANational Industrial Services LLC · Kingshill, VIBuilt 1983 · S/N 60-8423001 N914MBMedical Management Inc · Afton, WYS/N 60-8423008 N999LFPotts Rives · Dallas, TXBuilt 1984 · S/N 608423016

Back to AD 91-23-16