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.

N143MEGateway Of Sturgis LLC · Sturgis, MIBuilt 2000 · S/N 172S8427 N1444CFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9890 N1448ZNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9891 N1449CAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9892 N144CKClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13552 N144MEBell Enterprises Inc · Falls Church, VABuilt 2000 · S/N 172S8428 N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745 N145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429 N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430 N1463FSun Aircraft Management LLC · Ormond Beach, FLBuilt 2005 · S/N 172S9895 N1464CEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S9897 N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444 N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446 N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146 N1472PFlight School Of Texas LLC · Wilmington, DEBuilt 2005 · S/N 172S9899 N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219 N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451 N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585 N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452 N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896 N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125 N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185 N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528 N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415 N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900 N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903 N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565 N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996 N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453 N15222Southeast Aircraft Leasing LLC · Jacksonville, FLBuilt 2007 · S/N 172S10454 N1522RN1522r LLC · Mequon, WIBuilt 2008 · S/N 172S10716 N15255Elizabeth City State University · Elizabeth City, NCBuilt 2007 · S/N 172S10455 N152SAXd Aviation LLC · Castle Rock, COBuilt 2013 · S/N 172S11275 N153PCRegistered aircraftBuilt 2009 · S/N 172S10956 N1544CElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8365 N156DWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 172S8342 N156MEArcher III LLC · Littleton, COBuilt 2000 · S/N 172S8435 N157KCNorthwestern Michigan College · Traverse City, MIBuilt 2010 · S/N 172S11037 N157MEMaine Coastal Flight Center Inc · Bangor, MEBuilt 2000 · S/N 172S8436 N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255 N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805 N158SFAlba Leasing Services LLC · Scottsdale, AZBuilt 2006 · S/N 172S10368 N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256 N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816 N15ANAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13258 N15MJRegistered aircraftBuilt 2024 · S/N 172S13005 N1600UOsprey Holding Company LLC · Foley, ALBuilt 2005 · S/N 172S9905 N1608SNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S9907 N160MESilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172S8440 N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910

Back to AD 2012-22-01