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.

N6069SNelson Ronald E · Richmond, TXBuilt 1975 · S/N D-9821 N606BCBell Camp Inc · Lubbock, TXFirst renewal noticeBuilt 1980 · S/N EA-72 N606PBBoillat Pascal · Olympia, WABuilt 1984 · S/N 18504423 N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416 N606REPebblebrook Aviation LLC · Ellinwood, KSBuilt 1982 · S/N TJ-430 N606TWhitney Richard E Jr · Warrenton, VABuilt 1977 · S/N E-1155 N606WMHolt Timothy L · Foristell, MOBuilt 1995 · S/N 29-0070 N6070SEdward C Kole · Lake Geneva, WIBuilt 1975 · S/N D-9822 N6071BRoss Bryan L · Marion, MSBuilt 2003 · S/N 0566 N6072SMiller Walter Timothy · Henderson, NVBuilt 1975 · S/N D-9823 N6073SLocke Mary · Sherman, TXBuilt 1975 · S/N E-776 N6074SWatson Glenn M · Round Rock, TXBuilt 1975 · S/N E-778 N6075SJohnson Jamie D · Leonard, TXBuilt 1975 · S/N E-780 N60766Congdon Douglas J · Fairbanks, AKBuilt 1973 · S/N U20602044 N6078SWhisero Aero Inc · Tullahoma, TNBuilt 1975 · S/N TH-625 N607GSGaines Robert G · Howell, MIBuilt 1982 · S/N TK-147 N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071 N607PCCidale David R · Grand Island, NYBuilt 2005 · S/N 1624 N6081STearse David S · Swisher, IABuilt 1975 · S/N TE-1069 N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677 N60844Ayres Roger A · Henderson, NVS/N 18504062 N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678 N60871Young Greg W · Knoxville, TNBuilt 1980 · S/N 18504067 N6087SVega Peter · Thrall, TXBuilt 1975 · S/N E-784 N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141 N6089SVincent Shawn P · Hinsdale, ILFirst renewal noticeBuilt 1975 · S/N CE-617 N608AEFreedom Aviation LLC · Weatherford, TXBuilt 2003 · S/N 0611 N608EBPinnacle Roof Solutions LLC · New Baden, ILBuilt 1979 · S/N E-1512 N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N608RBKnudsen Russell G · East Troy, WIBuilt 1968 · S/N D-8818 N608RCRichland Aviation Inc · Sidney, MTS/N 404-0608 N6091SAir Transport Inc · Liberal, KSBuilt 1975 · S/N E-787 N6092SRobinson David John · Eads, TNBuilt 1975 · S/N D-9830 N6093SFarmer Scott · Springtown, TXBuilt 1975 · S/N D-9826 N60945Gray Rick L · Eagle River, AKBuilt 1980 · S/N 18504081 N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681 N60956Mcclellen Mark C · Mccall, IDBuilt 1980 · S/N 18504083 N6095ESmith Douglas Derek · Mebane, NCBuilt 1980 · S/N 18503996 N60969Northwest Aviation LLC · Whitefish, MTBuilt 1980 · S/N 18504085 N6096SMortensen Daniel R Trustee · Newhall, CABuilt 1975 · S/N TH-699 N6097SDonbee Farms Inc · Brawley, CABuilt 1975 · S/N E-789 N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266 N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713 N609AEGundersen Erik · Chino Hills, CABuilt 2003 · S/N 0609 N609AYAikawa Medical Management Co Inc Trustee · Cheyenne, WYBuilt 2022 · S/N 0920 N609CThorson Gregory · Mequon, WIBuilt 2003 · S/N 0440 N609CDCavu Aviation LLC · Huntsville, ALBuilt 2004 · S/N 0948 N609GMer Rouge Avion LLC · Bastrop, LABuilt 2008 · S/N TH-2235 N609KGGeiger Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 2005 · S/N 1731 N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802

Back to AD 86-13-04 R3