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.

N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200 N4DFCds Equipment LLC · Cincinnati, OHBuilt 2017 · S/N 310 N4FCFinco Aviation LLC · Sandy, UTBuilt 2009 · S/N 185 N4HDRegistered aircraftBuilt 2004 · S/N 029 N4SM4sm LLC · West Palm Beach, FLBuilt 2010 · S/N 244 N4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 107 N4WCMid-Atlantic Aviation IV LLC · St Petersburg, FLBuilt 2007 · S/N 137 N500BLBnb LLC · Wilmington, DEBuilt 1996 · S/N 08 N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303 N500FJGood Bus LLC · Midland, TXBuilt 2009 · S/N 182 N500JJUltimate Human Aviation LLC · Coconut Grove, FLBuilt 2007 · S/N 615 N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323 N500MAAndretti Autosport Aviation LLC · Fort Lauderdale, FLS/N 151 N500RHHms Holdings LLC · Charlotte, NCBuilt 2015 · S/N 315 N500WAWestern Aviation LLC · Fort Worth, TXBuilt 2010 · S/N 207 N501KLKl Air LLC · Mooresville, NCBuilt 2001 · S/N 007 N501MMN501mm LLC · North Little Rock, ARBuilt 1999 · S/N 99 N501NSoinair LLC · Beavercreek, OHBuilt 2007 · S/N 103 N501RRSpeedway Motorsports LLC · Charlotte, NCBuilt 2009 · S/N 200 N502BGCapital Holdings 209 LLC · Newark, DEBuilt 1995 · S/N 15 N502SVCryptologistics Of America Inc · Southwest Ranches, FLBuilt 1985 · S/N 502 N503DJDodson International Parts Inc · Rantoul, KSBuilt 2001 · S/N 145 N504PASmee Homes Inc · Porterville, CABuilt 1988 · S/N 43 N504STSdt Air Delaware LLC · Wilmington, DEBuilt 1996 · S/N 162 N504WTHerin Aviation LLC · Spring, TXBuilt 2019 · S/N 062 N506DJJrw Falcon LLC · Staten Island, NYBuilt 2001 · S/N 158 N506MWOgbjet III LLC · Overland Park, KSBuilt 2008 · S/N 150 N507DJFirm Foundation Aviation LLC · Brea, CABuilt 2001 · S/N 162 N508DJBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2001 · S/N 165 N508MMMarklyn Jet Parts LLC · Dallas, TXFirst renewal noticeS/N 66 N50BLBnb LLC · Wilmington, DES/N 2 N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187 N50LBRegistered aircraftBuilt 2023 · S/N 333 N50MWWj Of Delaware Inc · Fort Lauderdale, FLS/N 503 N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308 N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310 N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344 N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269 N510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 234 N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140 N510RHHms Holdings LLC · Charlotte, NCBuilt 2014 · S/N 282 N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122 N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123 N512KSMcreynolds Aviation LLC · Dallas, TXBuilt 2008 · S/N 217 N513DJCccnj F2000-169 LLC · Windermere, FLBuilt 2002 · S/N 169 N513HSRanch Stadium Equipment Leasing Inc · Dallas, TXBuilt 2006 · S/N 175 N513KDKd Aviation 51 LLC · Portland, ORBuilt 2002 · S/N 184 N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338 N515ANResources Aviation Inc · Fort Lauderdale, FLBuilt 2015 · S/N 284 N515CF5 Shues Leasing LLC · Waterford, MIFirst renewal noticeBuilt 2008 · S/N 170

Back to AD 2010-26-05 R1