Skip to content

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.

N562DDZoe Aviation Inc · Euless, TXBuilt 2000 · S/N 560-5108 N562HCH2c Air LLC · Cincinnati, OHBuilt 2003 · S/N 560-5350 N562JLMonreve LLC · Jacksonville, FLBuilt 2002 · S/N 560-5248 N562LDCasey Co · Long Beach, CABuilt 2004 · S/N 560-5532 N562TSJ-Six Enterprises LLC-J-Six Aviation Holdings Seri · Seneca, KSBuilt 2001 · S/N 560-5178 N562VPBruner Air LLC · Springfield, ILBuilt 2006 · S/N 560-5623 N563CSTulsa Xls LLC · Tulsa, OKBuilt 2005 · S/N 560-5563 N563DWDog Air LLC · Santa Clara, CABuilt 2014 · S/N 560-6169 N563XPTextron Aviation Inc · Wichita, KSBuilt 2006 · S/N 560-5617 N564CHCardinal Glass Industries Inc · Ocala, FLBuilt 2011 · S/N 560-6092 N564TATeam Aero LLC · Shawnee, KSS/N 560-5249 N564WS4way Split LLC · Bay Minette, ALBuilt 1998 · S/N 560-5014 N565CATextron Aviation Inc · Wichita, KSS/N 560-6523 N565HVHy-Vee Inc · West Des Moines, IABuilt 2019 · S/N 560-6269 N565QSNetjets Sales Inc · Columbus, OHBuilt 2008 · S/N 560-5818 N565RHMiles To Go LLC · Quincy, MABuilt 2018 · S/N 560-6257 N566FMidwest Ethanol Transport LLC · Granite Falls, MNBuilt 2005 · S/N 560-5606 N567MCN63xp LLC · Brea, CABuilt 2003 · S/N 5605357 N568LXLanier Equipment Leasing LLC · Gainesville, GABuilt 2007 · S/N 560-5680 N568QSNetjets Sales Inc · Columbus, OHBuilt 2008 · S/N 560-5829 N569MKKam Air LLC · High Point, NCBuilt 1998 · S/N 560-5006 N56WZAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5156 N570P10201 Air LLC · Omaha, NEBuilt 2006 · S/N 560-5628 N571BCInternational Bank Of Commerce · Oklahoma City, OKBuilt 1999 · S/N 560-5013 N573QSNetjets Sales Inc · Oklahoma City, OKFirst renewal noticeBuilt 2008 · S/N 560-5827 N574QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5820 N575QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5730 N576QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5708 N577PSPad One Holdings LLC · Wilmington, DEBuilt 2005 · S/N 560-5581 N577QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5735 N579MHJ1ap LLC · Naples, FLBuilt 2000 · S/N 560-5071 N579QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5773 N580QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5741 N582MPPaladin Adventures LLC · Westlake, TXBuilt 2026 · S/N 560-6517 N583QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5812 N585ESW G Yates & Sons Construction Co · Philadelphia, MSBuilt 2023 · S/N 560-6348 N586DZZeeco Inc · Broken Arrow, OKBuilt 2005 · S/N 560-5592 N587QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5805 N588CCE M Stivers Inc · Montgomery, ALBuilt 2007 · S/N 560-5687 N588QSNetjets Sales Inc · Columbus, OHBuilt 2007 · S/N 560-5721 N589QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5810 N590AKK & B Aviation Gp LLC · Houston, TXBuilt 1999 · S/N 560-5038 N590QSRegistered aircraftBuilt 2007 · S/N 560-5738 N591MATbfly LLC · Greenville, SCBuilt 2001 · S/N 560-5163 N591SFServisfirst Bank · Birmingham, ALBuilt 2021 · S/N 560-6298 N592QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5706 N595GEverything Aviation LLC · Trabuco Canyon, CABuilt 2002 · S/N 560-5224 N59ECJ M Z LLC · Columbus, OHBuilt 2000 · S/N 560-5123 N5RSRms Aviation LLC · Birmingham, ALBuilt 2001 · S/N 560-5196 N603TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 560-5338

Back to AD 2012-06-01