Skip to content

Registered aircraft · 266

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:2011-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-10-13') 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:2011-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-10-13')
  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:2011-10-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-10-13')
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.

N460TSGraham Aviation LLC · Belgrade, MTBuilt 2007 · S/N 42.AC060 N461PANichols Aviation LLC · Seattle, WABuilt 2007 · S/N 42.AC087 N461THIndiana State University · Terre Haute, INBuilt 2007 · S/N 42.AC044 N465ASSequoia Insight LLC · Houston, TXFirst renewal noticeBuilt 2007 · S/N 42.AC065 N469WWMx Jets Inc Trustee · Carson City, NVBuilt 2007 · S/N 42.AC074 N471HPMidwest Corp Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.138 N480TSAnodyne Of Savannah LLC · Newark, DEBuilt 2007 · S/N 42.AC080 N481MRWings Level Aviation LLC · Lake Mary, FLBuilt 2014 · S/N 42.N152 N483TSDouble Diamond Aviation LLC · Greenbrier, TNBuilt 2007 · S/N 42.AC083 N485AGDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC085 N485SVLima Alpha Struck LLC · Durham, NCBuilt 2019 · S/N 42.N387 N48DSEydon LLC · Boca Grande, FLBuilt 2007 · S/N 42.AC070 N490AGFxe Flightcenter Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 42.112 N490TSVories Dennis L Pe · College Place, WABuilt 2007 · S/N 42.AC090 N491TSCarter Stephen S Trustee · Rancho Santa Fe, CABuilt 2007 · S/N 42.AC091 N496TSDiamond 777 LLC · Chestnut Ridge, NYBuilt 2007 · S/N 42.AC096 N499BKAero Leasing Inc · Redding, CABuilt 2007 · S/N 42.AC099 N49AUAurora Flight Sciences · Manassas, VABuilt 2005 · S/N 42.008 N49TTTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 42.AC010 N503TSCox Aviation LLC · Portsmouth, RIBuilt 2007 · S/N 42.AC103 N505FMSeabreeze Mc LLC · East Islip, NYBuilt 2007 · S/N 42.AC048 N506SKFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC092 N508PAAlpha Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC079 N516LAGibbs John M · Monterey, CABuilt 2025 · S/N 42.N606 N518RMontgomery Dan G · Inverness, FLS/N 42.N404 N51AUAurora Flight Sciences · Manassas, VAFirst renewal noticeBuilt 2009 · S/N 42.MN004 N521QARbckmab LLC · Marlboro, NJBuilt 2018 · S/N 42.N336 N542BLSteel Aviation Inc · Phillipsburg, OHBuilt 2023 · S/N 42.N504 N5566AAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2023 · S/N 42.N518 N566CBValiair Lc Trustee · Casper, WYS/N 42.N111 N56AUAurora Flight Sciences Corp · Manassas, VABuilt 2015 · S/N 42.MN039 N56KDDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2007 · S/N 42.AC076 N574PADalero LLC · Lovettsville, VABuilt 2022 · S/N 42.N459 N5888Aviation Hub Inc Trustee · Cheyenne, WYBuilt 2023 · S/N 42.N270 N591ERDiamond Aircraft Sales U S A Inc · London OntarioNon-citizen corporation, flight hours not reportedBuilt 2006 · S/N 42.081 N593EREwers Mary E · Santa Fe, NMBuilt 2011 · S/N 42.NC001 N594ERFive Star Marketing Inc · Raleigh, NCBuilt 2007 · S/N 42.AC064 N596EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2019 · S/N 42.N382 N597EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 42.N389 N598EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 42.N390 N5999Aviation Hub Inc Trustee · Cheyenne, WYBuilt 2023 · S/N 42.N271 N599EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2020 · S/N 42.N392 N59LUPhoenix42 LLC · Meridian, IDBuilt 2009 · S/N 42.AC148 N607PADolphin Leasing LLC · Daytona Beach, FLBuilt 2007 · S/N 42.AC078 N610ASOrtega Aviation Services LLC · Wichita, KSBuilt 2009 · S/N 42.AC143 N614ZMTwin Eagles Aviation LLC · High Point, NCBuilt 2007 · S/N 42.AC113 N61EPWingsleasing LLC · Wichita, KSBuilt 2014 · S/N 42.N121 N621ZCSummit Aviation Inc · Belgrade, MTBuilt 2012 · S/N 42.NC002 N622GGDa42 LLC · Waterville, MEBuilt 2006 · S/N 42.AC023 N629SAMalone Air Holding LLC · Jacksonville, FLBuilt 2006 · S/N 42.AC011

Back to AD 2011-10-13