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.

N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912 N162CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13489 N162JKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13466 N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442 N163CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13492 N163MEAircraft Owners And Pilots Association Inc · Frederick, MDBuilt 2000 · S/N 172S8444 N1641CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11753 N1643CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11754 N1646CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11729 N1648CCoast Aviation LLC · Costa Mesa, CABuilt 2016 · S/N 172S11678 N1651CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11755 N1658CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11756 N165ARLago Enterprises LLC · Centennial, COBuilt 1998 · S/N 172S8018 N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752 N1664CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11757 N1668CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11758 N166CSAtp Aircraft 7 LLC · Wilmington, DEBuilt 2016 · S/N 172S11664 N1671CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11759 N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915 N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762 N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916 N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763 N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500 N167SJAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280167 N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188 N1683CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11764 N1687CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11731 N1688CAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10612 N1688LHeavy Metal Air LLC · Farmingdale, NYS/N 172S10613 N16894Saz Dynamics LLC · Daly City, CABuilt 2007 · S/N 172S10615 N16895Luxair LLC · College Station, TXBuilt 2007 · S/N 172S10618 N168CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13068 N168CBLogan Air Services LLC · Logan, UTBuilt 2002 · S/N 172S9119 N168YMewmew Investment II LLC · Palo Alto, CABuilt 2021 · S/N 172S12653 N1690LBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 172S10620 N169CBGiuffre Vi LLC · Milwaukee, WIBuilt 2002 · S/N 172S9247 N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234 N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449 N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404 N16GHGreysky LLC · Smyrna, TNBuilt 2026 · S/N 172S13519 N170CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13070 N170RBChristiansen Aviation LLC · Wilmington, DES/N 172S11130 N1710KCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13178 N1714TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12050 N1715TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12051 N171CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12332 N171MEPatriot Leasing LLC · Franklin, TNBuilt 2000 · S/N 172S8460 N171RACirrus Aviation Inc · Sarasota, FLBuilt 1999 · S/N 172S8237

Back to AD 2012-22-01