Registered aircraft · 726

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-06-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-06-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-06-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-06-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-06-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-06-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.

N604BPJp Citation Xl LLC · Carlsbad, CABuilt 2021 · S/N 560-6314 N604SDSworks Aviation LLC · Chicago, ILBuilt 2001 · S/N 560-5204 N604SNAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5181 N605TXPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2003 · S/N 560-5321 N606CBDecker Enterprises LLC · Ogden, UTBuilt 2003 · S/N 560-5333 N606HMWhipple Aviation LLC · Arkadelphia, ARBuilt 2000 · S/N 560-5127 N607TXMurfin Inc · Wichita, KSBuilt 2003 · S/N 560-5340 N608BTBamn Aviation LLC · Wilmington, DEBuilt 2007 · S/N 560-5728 N608JRExcel Aviation LLC · Birmingham, MIBuilt 2001 · S/N 560-5171 N608MBWhb Company Inc · Oklahoma City, OKBuilt 2020 · S/N 560-6296 N60FKConnair Consulting LLC · Jackson, TNBuilt 2001 · S/N 560-5211 N610TXPranidhana LLC · Farmingdale, NYBuilt 2002 · S/N 560-5312 N611BLDelco III LLC · Hickory, NCBuilt 2009 · S/N 560-5821 N611MRBmgi Aviation Xls I LLC · Fishers, INBuilt 2004 · S/N 560-5514 N613WMWeis Markets Inc · Sunbury, PABuilt 2012 · S/N 560-6115 N614TXPenn Aero Space Solutions LLC · Watsontown, PABuilt 2004 · S/N 560-5360 N616BZTripacific Aviation LLC · Villa Park, CABuilt 2004 · S/N 560-5519 N617CBCarroll Aviation Holdings LLC · Boston, MABuilt 2000 · S/N 560-5099 N617MWChoe Aviation Holdings LLC · Boston, MABuilt 2003 · S/N 560-5318 N619FKFks Aviation LLC · Richardson, TXBuilt 2008 · S/N 560-5777 N61FTAfa Southwest LLC · San Antonio, TXBuilt 2008 · S/N 560-5770 N620BDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 560-5794 N620SJFaulconer Energy LLC · Tyler, TXBuilt 2006 · S/N 560-5620 N620TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5299 N624WP624wp Holdings LLC · Indianapolis, INBuilt 2001 · S/N 560-5174 N625ATTechnology Value Investors Aviation LLC · Little Rock, ARBuilt 2001 · S/N 560-5175 N625XLW T B Financial Corp · Spokane, WABuilt 2012 · S/N 560-6125 N626TNSt Simons Aviation LLC · St Simons Island, GABuilt 2002 · S/N 560-5254 N629BTHbc Aviation LLC · Dallas, TXBuilt 2007 · S/N 560-5696 N62KWCricket Creek LLC · Springfield, MOBuilt 2016 · S/N 560-6205 N630CGCcgx LLC · Lexington, KYBuilt 2023 · S/N 560-6339 N631JDGoodwyn Partners LLC · Mobile, ALBuilt 2006 · S/N 560-5631 N632TXExcel Aviation LLC · Waukesha, WIBuilt 2004 · S/N 560-5358 N632XLCerulean II LLC · Wilmington, DEBuilt 2006 · S/N 560-5632 N634BE4 Solt LLC · Atlanta, GABuilt 2009 · S/N 560-6034 N635XLHorizon Group Services LLC · Millersburg, OHBuilt 2017 · S/N 560-6235 N636EJJk Air LLC · Fayetteville, ARBuilt 2002 · S/N 560-5304 N637AMTwo Wingz Charter LLC · Newport Beach, CABuilt 2000 · S/N 560-5137 N640AKIei Transport LLC · Dover, DEBuilt 2018 · S/N 560-6258 N641MSMs Aviation II LLC · Philadelphia, PABuilt 2007 · S/N 560-5684 N641SUIowa State University Of Science And Technology · Ames, IABuilt 2004 · S/N 560-5504 N643TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5295 N646TXKeystone Air LLC · Miami, FLBuilt 2002 · S/N 560-5246 N647MKLodge At Park Falls LLC · Reno, NVBuilt 2001 · S/N 560-5188 N64YCW G Yates & Sons Contruction Co · Philadelphia, MSBuilt 2018 · S/N 560-6261 N650CNCorporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 560-5294 N652CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 560-5326 N653CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2003 · S/N 560-5324 N654CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2005 · S/N 560-5542 N654PDMilk Source LLC · Kaukauna, WIBuilt 2017 · S/N 560-6236

Back to AD 2012-06-01