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.

N330KJet Sense Aviation Aircraft Holdings Corp · Lake Zurich, ILBuilt 2002 · S/N 189 N331DCBlue Bird Adventures LLC · Springfield, TNBuilt 2007 · S/N 601 N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163 N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14 N333MXHappy Travels LLC · Whitefish, MTBuilt 2007 · S/N 120 N338MJ A Real Estate Investments LLC · Fort Lauderdale, FLBuilt 2005 · S/N 66 N33BGBoyd Gaming Corp · Las Vegas, NVBuilt 2018 · S/N 352 N33VCSilver Lake Aviation LLC · Park City, UTBuilt 2021 · S/N 387 N341APAircroft LLC · Sarasota, FLBuilt 2003 · S/N 24 N345KMJdr Management LLC · Boca Raton, FLBuilt 1986 · S/N 3 N346EXWebair LLC · Warrenton, VAS/N 346 N34PCPace Falcon Leasing LLC · Plymouth, MIBuilt 2008 · S/N 156 N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41 N34VHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 432 N351MARugby Transit LLC · Boca Raton, FLBuilt 2008 · S/N 163 N353BLBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 049 N353WWBramac LLC · Denver, COBuilt 2012 · S/N 246 N355MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 265 N356LGRegistered aircraftBuilt 2009 · S/N 243 N358DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 003 N35CDCoastal Development Group LLC · Boca Grande, FLFirst renewal noticeBuilt 1989 · S/N 224 N35KVMit Oregon LLC · Portland, ORBuilt 2001 · S/N 083 N360DMMaund Doug · Austin, TXBuilt 2003 · S/N 210 N360FCNbftm LLC · Saint Paul, MNBuilt 2004 · S/N 042 N360GBHanging Valley Aviation LLC · Green Bay, WIBuilt 2025 · S/N 422 N360MAir4 Aviation LLC · Houston, TXBuilt 2005 · S/N 68 N360SMChowdhury Aviation LLC · New York, NYBuilt 2000 · S/N 113 N361DDWeco West LLC · Catarina, TXBuilt 2000 · S/N 72 N361KBpcp Falcon N361k LLC · Wilmington, DES/N 83 N362PTN378c LLC · Parker, COS/N 73 N364AEHayden Gray LLC · Dallas, TXBuilt 1997 · S/N 036 N365AGAga Holdings LLC · Waterford, MIBuilt 2004 · S/N 50 N365LTProductivity Advantage Inc · Mosinee, WIBuilt 2023 · S/N 405 N365TX235jb LLC · Lewes, DEBuilt 1998 · S/N 56 N368MBAffiliated Investments LLC · Auburn Hills, MIBuilt 2001 · S/N 161 N36EPJsm At Falcon II LLC · Piscataway, NJBuilt 2001 · S/N 172 N370MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 126 N3712CF900ex LLC · Minneapolis, MNBuilt 1996 · S/N 04 N372EXReal Estate Services International LLC · Conshohocken, PABuilt 2003 · S/N 12 N373EFEmpirical Foods Inc · Dakota Dunes, SDBuilt 2014 · S/N 275 N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259 N373RSKalamazoo Group II LLC · Kalamazoo, MIBuilt 2015 · S/N 291 N374RVLmrv Falcon LLC · Phoenix, AZBuilt 2018 · S/N 745 N375GKKs Air 3-7-12 V LLC · Charlotte, NCBuilt 2004 · S/N 46 N376SFSmithfield Packaged Meats Corp · Smithfield, VABuilt 2009 · S/N 176 N377AGCrest Operations LLC · Pineville, LABuilt 2004 · S/N 032 N37DFWillamette Flight Management LLC · Mcminnville, ORBuilt 2004 · S/N 37 N37EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 58 N37MDTriangle Aviation LLC · Dover, DEBuilt 1996 · S/N 32 N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309

Back to AD 2010-26-05 R1