Registered aircraft · 16

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-16-02') 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-16-02') 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-16-02')
    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-16-02')
  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-16-02')
  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-16-02')
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.

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N155JECjb Equipment Leasing LLC · Naples, FLBuilt 2003 · S/N 6633 N155RBAerospace Trust Management LLC Trustee · Wilmington, DES/N 6583 N155RDCastro Be LLC · Miami, FLBuilt 2000 · S/N 6580 N155TDAjd Aviation LLC · Dorado, PRS/N 6664 N155UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6934 N156UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6935 N157UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6933 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2019 · S/N 7055 N725LLMilton S Hershey Medical Center · Hershey, PABuilt 2013 · S/N 6983 N758MMTrevor Corp DBA · Grayslake, ILS/N 6761 N759MMTrevor Corp DBA · Grayslake, ILBuilt 2007 · S/N 6777 N797AZMwa6 LLC · Waterford, MIS/N 6746 N916LLMilton S Hershey Medical Center · Hershey, PABuilt 2011 · S/N 6885 N921LLMilton S Hershey Medical Center · Hershey, PABuilt 2015 · S/N 7002

Back to AD 2012-16-02