Skip to content

Registered aircraft · 1,572

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

N101HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000156 N101LRegistered aircraftBuilt 2023 · S/N 2302 N101PKMassey Air Inc · Lucdale, MSBuilt 2016 · S/N 1610 N102HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000157 N102TP2 T Partnership Ltd · Pecos, TXBuilt 2025 · S/N 2439 N103HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000159 N104HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000160 N104SCLsac Enterprises LLC · Marshalltown, IABuilt 2020 · S/N 2032 N105HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000163 N106HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000164 N106SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000399 N106TWTw Leasing LLC · Oxford, CTS/N 1109 N1073PTvpx Ars Inc Trustee · North Salt Lake, UTS/N 19000107 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 N108MPAircraft Propeller Service LLC · Lake Zurich, ILS/N 19000108 N109HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000168 N109SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000404 N10DFGulf States Toyota Inc · Houston, TXS/N 1241 N10WAReinbeck Motors Co Inc · Reinbeck, IABuilt 2022 · S/N 2187 N110GNWell Adjusted LLC · Naples, FLBuilt 2013 · S/N 1404 N110GWGew Aircraft Leasing LLC · Naples, FLBuilt 2013 · S/N 2457 N110HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000172 N111HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000173 N111NHE190 Msn111 LLC · Dover, DEBuilt 2007 · S/N 19000111 N112BZBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 19000077 N112HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000174 N113BDBlack Dog Leasing LLC · Gardnerville, NVBuilt 2024 · S/N 2414 N113HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000177 N114BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000092 N114HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000179 N114SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000410 N1150HLbj Air LLC · Helena, MTBuilt 2009 · S/N 1150 N1150NBlack Falcon Leasing LLC · Gallatin, TNBuilt 2009 · S/N 1156 N115BZWilmington Trust Co Trustee · Wilmington, DES/N 19000096 N115HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000182 N116BZWilmington Trust Co Trustee · Wilmington, DES/N 19000101 N116HQRepublic Airways Inc · Carmel, INBuilt 2007 · S/N 17000183 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 N118NGAvodah Blue LLC · Logan, UTBuilt 2018 · S/N 1833 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 N119UTUnited Therapeutics Corp · Silver Spring, MDBuilt 2015 · S/N 1520 N11BYRj Aviation LLC · Ronkonkoma, NYBuilt 2023 · S/N 2295 N11NXDiscovery Associates Inc · Midland, TXBuilt 2020 · S/N 2010 N11NYKup Air LLC · Mccook, NEBuilt 2016 · S/N 1647

Back to AD 2010-09-04