Skip to content

Registered aircraft · 3,852

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-01') 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-01') 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-01')
    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-01')
  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-01')
  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-01')
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.

N1730SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12281 N1731SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12282 N1732SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12283 N1733SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12284 N1734SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12285 N1735XAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10648 N1738SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12287 N173AWLongwing Company LLC · Plymouth, MNBuilt 2022 · S/N 172S12859 N173DCSkyvibe Leasing LLC · Aurora, ORBuilt 2016 · S/N 172S11720 N173MEBox Aviation Inc · Montgomery, ALBuilt 2000 · S/N 172S8455 N173PBLee Bradford W · Austin, TXBuilt 2003 · S/N 172S9442 N17409Cirrus Aviation Inc · Sarasota, FLBuilt 2008 · S/N 172S10660 N1740CAmerican Aviation Inc · Brooksville, FLBuilt 2007 · S/N 172S10610 N1740TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12087 N1741SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12288 N1742SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12289 N1743LAir Inter LLC · Pittsburgh, PABuilt 2008 · S/N 172S10665 N1743SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12290 N1745SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12291 N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489 N174GFMarcus Air LLC · Plano, TXBuilt 1998 · S/N 17280532 N174HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8257 N174MEMaxxum Financial Group Inc · Destrehan, LABuilt 2000 · S/N 172S8452 N174THGh174th LLC · Jericho, NYBuilt 2020 · S/N 172S12442 N1752TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12097 N1754TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12099 N1756TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12104 N175MENorth Perry Flight Center Inc · Fort Lauderdale, FLBuilt 2000 · S/N 172S8437 N1760TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12108 N1762TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12109 N1766TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12110 N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287 N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470 N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115 N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111 N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112 N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113 N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114 N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177 N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039 N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491 N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978 N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769 N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598 N17SJAnson Air LLC · Sugar Land, TXBuilt 1999 · S/N 172S8344 N1806MCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13177 N180CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12727 N180SUOhio State University · Columbus, OHBuilt 2018 · S/N 172S12161 N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169

Back to AD 2012-22-01