Registered aircraft · 18,495

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.

N9178GUrsus Air Services · Anchorage, AKBuilt 1977 · S/N U20603803 N9178JCrawley Rohan · Bloomington, INS/N 28-3244 N9179QDewitt Weldone · Brashear, TXBuilt 1971 · S/N CE-331 N9179XJohnson Randolph B · Wichita Falls, TXBuilt 1992 · S/N E2759 N917CDRiendl Jay Joseph · Colorado Springs, COBuilt 2002 · S/N 0350 N917DCRegistered aircraftFirst renewal noticeBuilt 1981 · S/N E-1884 N917DDAir Serve LLC · Woodbine, NJBuilt 1977 · S/N 21061752 N917DMCarey Keith W · Rockvale, TNBuilt 2004 · S/N 1112 N917JKJen-Kel Aviation LLC · Sarasota, FLBuilt 1975 · S/N E-652 N917MPPool Shark Equipment LLC · Memphis, TNBuilt 1981 · S/N TH-1243 N917SDTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9988 N917TRTry Trying Management And Promotions LLC · Indianapolis, INS/N TH-133 N917WCBarr Air Patrol LLC · Mesquite, TXBuilt 1973 · S/N U20602032 N9180STowns Michael J · Corpus Christi, TXBuilt 1977 · S/N U20603996 N9183BSteller Aviation LLC · Middletown, DEBuilt 1991 · S/N E-2631 N9186QGaines Norse · Irvine, CABuilt 1971 · S/N CE-332 N9186TEpi Technologies Inc · Antioch, ILBuilt 1977 · S/N 21062227 N9188MSturgis Jason A DBA · Talkeetna, AKBuilt 1970 · S/N U20601588 N918BVDietz John W Jr · Westfield, INBuilt 1982 · S/N 421C1247 N918MHN918mh LLC · Little Rock, ARBuilt 1968 · S/N CE-216 N9192MHandelin Gary W · Carson City, NVBuilt 1970 · S/N U20601592 N9192QMonroe Aviation Inc · Verona, PABuilt 1971 · S/N E-259 N9195QMeadowlake Airpark LLC · Lenoir City, TNBuilt 1971 · S/N TH-152 N9199QCramer Todd L · Fort Mohave, AZBuilt 1971 · S/N CE-334 N919BFStc Aviation LLC · Wilmington, DES/N 310R0124 N919CAvventura Del Volo LLC · Nashville, TNBuilt 2004 · S/N E-3563 N919CBCatclaw Aviation LLC · San Antonio, TXBuilt 1981 · S/N 414A0672 N919CDHigh Wings Inc · York, PABuilt 2002 · S/N 0278 N919FAFortnum Air LLC · Dana Point, CAS/N 414A0628 N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054 N919PJDel Rosso Peter · Los Angeles, CABuilt 1981 · S/N TK-140 N919RRodriguez Daniel L · West Linn, ORS/N 21059032 N919TLRegistered aircraftBuilt 2002 · S/N 0182 N919TPWarren Jason J · Silverdale, WABuilt 1977 · S/N D-10068 N91CESchwartz Stacy L · Windsor, NYBuilt 1969 · S/N 30206 N91DCarterdawg Real Estate And Aircraft Holdings LLC · Fort Worth, TXBuilt 1967 · S/N TE-496 N91DDLonghorn Leasing LLC · Anchorage, AKS/N EA-511 N91DMHead Joseph A · Fairbanks, AKBuilt 1976 · S/N 18503137 N91JPJackson Gerald M · Lake City, MIBuilt 1975 · S/N D-9810 N91JRSpring Mountain Properties LLC · Fort Smith, ARBuilt 1973 · S/N TH-313 N91JTHoran Raj · Plainview, TXBuilt 1991 · S/N 91-301014 N91KMj Aviation Inc · Custer, SDBuilt 1975 · S/N D-9764 N91SDFlying High LLC · Plainfield, ILBuilt 1986 · S/N 4608035 N91TWPistol Aviation LLC · Stillwater, OKBuilt 1978 · S/N 414A0117 N91VPBravo Sierra Holdings LLC · Downers Grove, ILBuilt 1969 · S/N D-9035 N91YRRegistered aircraftBuilt 1991 · S/N CE-1634 N9200QHenning Lowell W · Haslet, TXBuilt 1971 · S/N CE-335 N9203QDavis & Automotive Services Inc · Carlinville, ILBuilt 1971 · S/N E-261 N9204GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801423 N9204HTongass Air LLC · Ketchikan, AKBuilt 1977 · S/N 18503421

Back to AD 86-13-04 R3