Registered aircraft · 1,068

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

N298RDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 024 N299FGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2009 · S/N 224 N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299 N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343 N2NLCenturion Investments Inc · Chesterfield, MOBuilt 1997 · S/N 017 N301AFAir4 Aviation LLC · Houston, TXBuilt 1996 · S/N 44 N301MTRegistered aircraftBuilt 2007 · S/N 117 N303CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 061 N303TFNtc Aviation LLC · Greenwich, CTBuilt 2024 · S/N 44 N304KSonic Automotive Inc · Charlotte, NCBuilt 2016 · S/N 304 N306BHSdy Leasing LLC · Waterford, MIBuilt 2005 · S/N 220 N306SHN306sh LLC · Chicago, ILBuilt 1995 · S/N 150 N307MDN307md LLC · Barrington, RIBuilt 2007 · S/N 105 N30HQLearjet Inc · Wichita, KSBuilt 1999 · S/N 045 N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152 N310ZAZair Force One LLC · Mendenhall, MSBuilt 1987 · S/N 009 N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314 N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135 N312SHRegistered aircraftBuilt 2011 · S/N 251 N313JLJnl Equipment Leasing LLC · Camden, DEBuilt 2008 · S/N 192 N313PJRpc Aviation LLC · Fayetteville, ARBuilt 2000 · S/N 302 N313RHRedwood Holdings LLC · Hanover, MDBuilt 2023 · S/N 404 N313STIota Aviation LLC · Bloomfield Hills, MIBuilt 2004 · S/N 121 N313WATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2009 · S/N 197 N314SJHrm Aviation LLC · Chesterfield, MOBuilt 1992 · S/N 115 N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315 N315REGrey Goose LLC · Pleasant Prairie, WIBuilt 2021 · S/N 375 N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130 N316GBWellsprings Aviation LLC · Winston Salem, NCS/N 103 N317DTN42nh LLC · Oklahoma City, OKBuilt 1994 · S/N 04 N317MNext Level Marine LLC · Mount Pleasant, TXBuilt 2002 · S/N 188 N317MLMds Falcon LLC · Kittanning, PABuilt 2005 · S/N 158 N319CFOcean Drive Bulgaria Corp · Wilmington, DEBuilt 2001 · S/N 319 N320GWSky Wheeels LLC · Prince Frederick, MDBuilt 1981 · S/N 180 N321AJM Hixson Aviation LLC · Denton, TXBuilt 2000 · S/N 77 N321AKSnails Pace Aviation LLC · New York, NYBuilt 2008 · S/N 222 N321APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 264 N321EJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 87 N3221BAurum Aviation LLC · Dallas, TXBuilt 2003 · S/N 14 N322FJRegistered aircraftBuilt 2020 · S/N 322 N322RRNion LLC · New Century, KSBuilt 1995 · S/N 514 N323SEWard Ohara Companies LLC · Kansas City, MOBuilt 2008 · S/N 151 N324SLAp Aviation LLC · Troy, VABuilt 2001 · S/N 91 N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325 N325GMRegistration Pending · Salt Lake City, UTRegistration pendingBuilt 2001 · S/N 164 N326EWLeco Corp · South Bend, INBuilt 2012 · S/N 248 N3278Peregrine Falcon LLC Trustee · Boise, IDBuilt 2001 · S/N 01 N327LXBoston Post Leasing LLC · Nashua, NHBuilt 2016 · S/N 327 N327RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 274 N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157

Back to AD 2010-26-05 R1