Skip to content

Registered aircraft · 1,791

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

N100ACSmith Vicars & Co LLC · Charlottesville, VABuilt 2002 · S/N 5546 N101HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000156 N101KFTravers 6 LLC · Chesterfield, MOS/N 5564 N102HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000157 N103HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000159 N103SYSkywest Airlines Inc · Saint George, UTBuilt 2014 · S/N 17000390 N104HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000160 N105HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000163 N105SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000395 N106HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000164 N106SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000399 N107HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000165 N107SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000400 N108HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000166 N108SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000401 N109HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000168 N109SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000404 N10MMSarma Aviation LLC · Fort Wayne, INBuilt 1988 · S/N 5033 N1101AHeritage Aviation Services LLC · Dallas, TXBuilt 1997 · S/N 5354 N110HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000172 N110SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000405 N111CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1996 · S/N 5192 N111HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000173 N112HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000174 N113HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000177 N113SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000407 N114HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000179 N114SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000410 N115HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000182 N116HLWorld Tech Aviation LLC · Valencia, CAS/N 5113 N116HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000183 N116SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000411 N117HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000184 N117SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000416 N118HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000189 N118MTOne World Aviation 118 LLC · Atlanta, GAS/N 5077 N118SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000420 N119HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000190 N119SYSkywest Airlines Inc · Saint George, UTBuilt 2014 · S/N 17000421 N120HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000193 N120SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000425 N121HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000194 N121SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000430 N122HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000196 N122SYSkywest Airlines Inc · Saint George, UTBuilt 2014 · S/N 17000431 N123HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000199 N124HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000200 N124SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000439 N125HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000202 N125JJNeves LLC · Elizabethtown, KYS/N 5412

Back to AD 2021-18-13