Registered aircraft · 63

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

N5843KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 1071 N5869KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1205 N5879KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1226 N5881KUmb Bank Na Owner Trustee · Salt Lake City, UTBuilt 2010 · S/N 1167 N5897KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 1245 N7019KAmazon.Com Services LLC · Seattle, WAS/N 1359 N7057KAmazon.Com Services LLC · Seattle, WAS/N 1546 N817CMCargo Aircraft Management Inc · Wilmington, OHS/N 1269 N821CMCargo Aircraft Management Inc · Wilmington, OHS/N 1146 N828CAAc Spe 13 LLC · Orlando, FLBuilt 2012 · S/N 1279 N873CAAc Spe 12 LLC · Orlando, FLBuilt 2012 · S/N 1348 N898CAAc Spe 14 LLC · Orlando, FLBuilt 2011 · S/N 1208 N968AVAircol 5 · Wilmington, DEBuilt 2009 · S/N 1009

Back to AD 2012-22-18