Registered aircraft · 18,497

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

N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384 N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035 N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180 N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036 N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386 N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390 N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741 N223BBN223bb LLC · Great Falls, VABuilt 2000 · S/N E-3340 N223DBurch Construction Co Inc · Ramona, CABuilt 1993 · S/N CE1755 N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447 N223KWMedic Choppers LLC · Springdale, ARS/N EA-382 N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493 N223MKKaul Mahendra · Bainbridge Island, WABuilt 2004 · S/N 1003 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339 N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999 N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391 N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186 N2241TWhittock Tyson H · Anchorage, AKS/N 185-1397 N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754 N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396 N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191 N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398 N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193 N224ABSkin LLC · Charlotte, NCBuilt 1992 · S/N CE-1680 N224ARAvtac Solutions LLC · Oneida, TNBuilt 2001 · S/N 0137 N224CAGas Aviation LLC · Elk City, OKBuilt 2010 · S/N TH-2279 N224CHMadden Jeffrey M · Queensbury, NYBuilt 1976 · S/N 18503075 N224DGFahrer Scott M · Sunrise Beach, MOBuilt 2002 · S/N 0275 N224DLHagglund Carl · Pendleton, ORBuilt 1968 · S/N E-61 N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599 N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660 N224EBVasquez Aviation LLC · Lake Placid, FLBuilt 2005 · S/N 1287 N224GRHaufe Nicole C · Madeira Beach, FLBuilt 2003 · S/N 0626 N224HPNguyen Cody · Richmond, CABuilt 1965 · S/N D-7806 N224JC109 Ventures & Agency Services Inc · Glenburn, MEBuilt 2004 · S/N 0914 N224JGGuillory Mark T · Pineville, LABuilt 2004 · S/N 1013 N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812 N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179 N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155 N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089 N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170 N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016 N224RGBonanza Aircraft Inc Trustee · Cheyenne, WYBuilt 2009 · S/N E-3894 N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595 N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152 N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705 N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882 N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184 N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570

Back to AD 86-13-04 R3