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.

N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281N4682QHangar 27 LLC · Bountiful, UTS/N 21059582N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285N4685MCbh LLC · Madison, CTBuilt 1978 · S/N D-10143N4688AKnutson Ronald J · Tacoma, WABuilt 1970 · S/N D-9183N4688CAeropod Inc · Aurora, COBuilt 1976 · S/N 18502877N4689CAeropod Inc · Aurora, COBuilt 1974 · S/N 18502596N4689QJohnson Tod W · Three Rivers, CABuilt 1972 · S/N 21059589N468ABrown Michael E · Wasilla, AKBuilt 1967 · S/N D-8548N468DABulk Transfer LLC · Horseshoe Bay, TXBuilt 2006 · S/N 29-0417N468MSSturdivant Mike P Jr · Glendora, MSBuilt 1980 · S/N 21063969N468PN Fl Servicing LLC · Santa Rosa Beach, FLBuilt 2000 · S/N TH-1965N468SRMarkoff M Daniel · Las Vegas, NVBuilt 1969 · S/N CE-276N4690CGreen Aviation Inc · Manchester, MEBuilt 1974 · S/N 18502597N4690UKim Hansen Co · Burley, IDBuilt 1979 · S/N U20605059N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988N4694ZKyro Consulting LLC · Williamsburg, VABuilt 1988 · S/N 4608115N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598N4698RCorl Jason · Stanton, CABuilt 1969 · S/N CE-277N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299N469CDRockin Robin Aviation LLC · Natchez, MSBuilt 2005 · S/N 1555N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018N469HHowatt Air Inc · Langdon, NDBuilt 2005 · S/N 1333N469HPTrussell David · Fremont, CABuilt 1985 · S/N 46-8508109N469MMMm Consulting Services · Fort Smith, ARS/N 29-0243N46BAArrington Investments Inc · Andrews, SCBuilt 1998 · S/N 29-0161N46BBQuinby Bruce · Kingston, TNBuilt 1968 · S/N TE-580N46CPKtas LLC · New York, NYS/N E-2430N46CRBas Part Sales LLC · Greeley, COBuilt 1986 · S/N 46-8608021N46CSPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N P21000413N46DMEdwards John Guerrant · Stoneville, NCBuilt 1979 · S/N TH-1048N46DTEagle Ad-Venture LLC · Universal City, TXBuilt 2000 · S/N 29-0254N46EHStar H Aviation LLC · Plano, TXBuilt 1988 · S/N 4608108N46GLawton Richard L · Durango, COBuilt 1971 · S/N CE-353N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071N46JJWoods Terence R · Ankeny, IABuilt 1981 · S/N D-10375N46JKJm Aircraft Inc · Hickory, NCS/N 4608105N46LAMagoon Paul J · Merrimack, NHBuilt 1986 · S/N 46-8608055N46LEKepley Aviation LLC · Smyrna, TNS/N E726N46MBAig Aeronautics LLC · Guaynabo, PRBuilt 1984 · S/N 46-8508021N46MGHughes Shaun · Everett, WABuilt 1988 · S/N 4608136N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778N46PAAyer William S · Bellevue, WABuilt 1984 · S/N 46-8408060N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105N46PKTensas Taildraggers LLC · Saint Joseph, LABuilt 1978 · S/N U20604437N46TESerenity Aero LLC · Cape Girardeau, MOBuilt 2005 · S/N 1694
Back to AD 86-13-04 R3