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.

N1242BMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10307 N1242NBg-Ip LLC · Saratoga, CABuilt 2006 · S/N 172S10309 N124CKChristiansen Aviation LLC · Wilmington, DEBuilt 2005 · S/N 172S9808 N124HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9632 N124MEJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8372 N124PLL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8194 N124WEMidwest Aviation Inc · Mayfield, KYBuilt 2019 · S/N 172S12393 N1250KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13050 N1254DAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10127 N125TWSmith Susan · Scottsdale, AZBuilt 2023 · S/N 172S13023 N125WEOhio State University · Columbus, OHBuilt 2019 · S/N 172S12303 N1260KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13053 N1261Evy Holdings Inc · White Marsh, MDBuilt 2006 · S/N 172S10322 N126AAAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10076 N126AVN106ka LLC · Manassas, VAS/N 172S10621 N126BSCape Island Aviation LLC · Millville, NJBuilt 2017 · S/N 172S12012 N126HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9053 N126MEGlobal Flight Training Solutions Inc · Immokalee, FLFirst renewal noticeS/N 172S8378 N126SPPilling Stephen · Southport, NCBuilt 2005 · S/N 172S9796 N1270KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13057 N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846 N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532 N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335 N1289YBravo Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9851 N128SCIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 172S8250 N128SHCalifornia In Nice Inc DBA · San Jose, CABuilt 2020 · S/N 172S12457 N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667 N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825 N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210 N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012 N1305BTriangle Aviators LLC · Cary, NCBuilt 2007 · S/N 172S10654 N1306CWateractive43 LLC · Auburn, CABuilt 2007 · S/N 172S10655 N1306MFreedom Aviation Inc · Lynchburg, VABuilt 2006 · S/N 172S10336 N1307CHouse Of Raeford Farms Inc · Rose Hill, NCBuilt 2006 · S/N 172S10337 N1309GPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10342 N130JAHagele Aviation LLC · Hillsboro, ORBuilt 2002 · S/N 172S9165 N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344 N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657 N131AZSuraair Holdings Inc · Wilmington, DEBuilt 2012 · S/N 172S11165 N1322KCleared Into Bravo LLC · Sunnyvale, CABuilt 2006 · S/N 172S10345 N1323KFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10348 N1323XMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10367 N1327NGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10380 N1327ZN1327z LLC · Palm City, FLBuilt 2005 · S/N 172S9867 N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176 N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189 N1330NEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10396

Back to AD 2012-22-01