OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,498

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.

N164MDehaan David J · San Diego, CABuilt 2010 · S/N TH-2295N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250N1650ZRobinson Christopher C · Olivet, MIBuilt 1962 · S/N 185-0450N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687N1655CMardis Nicky Lee · Goddard, KSBuilt 1953 · S/N 30355N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690N1656CAnderson Thomas R · Seattle, WABuilt 1953 · S/N 30356N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258N165DBCloud 916 LLC · Dover, DEBuilt 1978 · S/N 18503624N165DFMarks James E · Valatie, NYBuilt 1967 · S/N 185-1267N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180N1662RGray Jerry B · Valdez, AKBuilt 1974 · S/N 18502385N1663COlson Aviation LLC · Chandler, AZBuilt 2003 · S/N 0585N1663RSmith Dan V · Anchorage, AKBuilt 1974 · S/N 18502386N1665CTaylorsville Lake Marina Inc · Simpsonville, KYBuilt 2003 · S/N 0587N1667MTen Mile Ranch Inc · Vale, ORBuilt 1971 · S/N 18501859N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268N1669MC Y Transport LLC · Columbus, MNBuilt 1971 · S/N 18501861N1669WBahri Kiumars · Birmingham, ALBuilt 1972 · S/N CE-392N166BVSensing Aviation LLC · Nashville, TNBuilt 2000 · S/N TH-1958N166CCValkyrie Aero LLC · Mesa, AZBuilt 1954 · S/N CG-21N166TRBourn Bryan · Jordan, MNBuilt 2002 · S/N 0264N166ZUsda Forest Service Fire & Aviation · Boise, IDBuilt 1986 · S/N U20606923N1670THyde Family Aviation LLC · Wilmington, DEBuilt 1973 · S/N 414-0463N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382N1673MBower Ashley R · Anchorage, AKBuilt 1971 · S/N 18501865N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258N1675MWenk Peter J · Ocala, FLBuilt 1971 · S/N 18501867N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401N1678TGabaldon Martin · El Paso, TXS/N 414-0471N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713N1679MVaughns Flying Service Inc · Reese, MIBuilt 1971 · S/N 18501870N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167NGohman Charles Scott · Salinas, CAS/N TE-137
Back to AD 86-13-04 R3