OpenAirDocs.org
AD 86-13-04 R3

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
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.

N5WMMerrell Warren · Idalou, TXBuilt 1975 · S/N E-649N5XLLove John R · Sutton, MABuilt 1972 · S/N D-9334N5ZRBeasley Timber Co Inc · Hazlehurst, GABuilt 2005 · S/N TH-2128N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N6001F2120 Limited LLC · Flushing, MIBuilt 1965 · S/N D-7794N60034Jpb Holdings Inc · Kalispell, MTBuilt 2003 · S/N 0596N6005CWings And Wedges LLC · Fort Lupton, COS/N 0597N6005LPeairs Gregory Ross · Sacramento, CABuilt 2003 · S/N 0563N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875N6008FShared 08f Inc · Pensacola Beach, FLBuilt 1965 · S/N D-7798N600AFClark Development LLC · Dekalb, ILBuilt 1980 · S/N E-1803N600BBGat Air & Ground LLC · Norwich, NYFirst renewal noticeBuilt 1981 · S/N TH-1236N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007N600EJQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N NAV-4-2543N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600MDDowning Scott L · Fitzgerald, GABuilt 1965 · S/N D-7803N600MSInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N E-995N600NUN600nu LLC · New Meadows, IDFirst renewal noticeBuilt 1977 · S/N U20603976N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600PESpringair Inc Trustee · Wilmington, DEBuilt 2014 · S/N TH-2404N600RVAero-Tech Services Inc · Lititz, PABuilt 1998 · S/N TH-1854N600SKMorin Aviation LLC · Accident, MDBuilt 2005 · S/N 1495N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668N600WLMoore Stan D · Amarillo, TXBuilt 1979 · S/N P21000409N600ZZGsair Inc · Wilmington, DEBuilt 1973 · S/N E-400N601Mont Belvieu Materials Inc · Mont Belvieu, TXBuilt 1969 · S/N 185-1567N6012BQualitair LLC · MichelstadtBuilt 2003 · S/N 0598N6012SWhaley Carl S · Shelby, NCS/N TJ-15N60134Smith Eddie D · Wasilla, AKBuilt 1973 · S/N U20602011N6013BFrost Sean D · Lovell, WYS/N 21062664N6013UGideon Aero LLC · Dayton, OHBuilt 2003 · S/N 0603N6016FHanson Enterprises Inc · Hamel, MNBuilt 1965 · S/N D-7823N6017SEisma Thomas Eugene · Golden, COBuilt 1975 · S/N TJ-17N6018SJohnson Thomas G · New Port Richey, FLS/N TJ-19N6019FFlying R LLC · Apison, TNBuilt 1965 · S/N D-7901N6019QNeufeld Wilhelm Loewen · Presidio, TXBuilt 2003 · S/N 0637N6019ZRankin James L · Carmel, INBuilt 2003 · S/N 0599N601BTCoats George A · The Woodlands, TXBuilt 1989 · S/N CE-1371N601SWDynaero LLC · South Vineland, NJBuilt 1976 · S/N E904N601UJBurton Donald O · Mooresville, NCBuilt 1966 · S/N D-8117N6020NWatts Carl · Thousand Oaks, CABuilt 1978 · S/N 21062888N6023QCr Mcdowell Construction Co Inc · Keokuk, IABuilt 1979 · S/N E-1441N6023UHigh Scott · Albuquerque, NMBuilt 1979 · S/N E-1442N6023ZSchmauderer Ivan K · Woodland, CABuilt 1979 · S/N E-1468N6024AAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1979 · S/N D-10210N6024KNabarrette Angel · Odessa, TXBuilt 1979 · S/N TJ-187N6024SAdams Erik S · Bozeman, MTBuilt 1975 · S/N TJ-16N6024XWmrm LLC · Saint Petersburg, FLBuilt 1979 · S/N CE-863
Back to AD 86-13-04 R3