OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N3732FInderwiesen Nancy A · Cleveland, MOBuilt 1980 · S/N WA-154N37332Shay Jonathan P · El Cajon, CABuilt 1980 · S/N WA-164N3733CBarber Ted · Huntington, NYFirst renewal noticeBuilt 1980 · S/N WA-151N3733DSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1980 · S/N ME-362N3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1980 · S/N ME-364N3733QChalender Robert C · Cocoa, FLBuilt 1967 · S/N TE-294N37345Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N WA-158N3734NSelect Aerospace Industries · Weyers Cave, VABuilt 1947 · S/N D-944-R9N3734QInternational Aviation Industries LLC · Kalispell, MTS/N TE-303N3734UDaricl LLC · Shoreham, NYBuilt 1980 · S/N M-2290N3734ZSheetz Richard A · Edmond, OKBuilt 1980 · S/N MC-739N37350Price Brenda · Poplar Bluff, MOBuilt 1980 · S/N E-1768N3735BBas Part Sales LLC · Greeley, COBuilt 1982 · S/N D-10403N3735RJones Larry L · Paragould, ARS/N WA-171N3735TGarner Brian J · Bluffdale, UTBuilt 1980 · S/N E-1764N3736DRodriguez Alberto R · San Juan, PRBuilt 1980 · S/N E-1766N3737KCavanaugh Kirk M Trustee · Homer Glen, ILBuilt 1982 · S/N E-2019N3737LClark Julie E · Cameron Park, CABuilt 1980 · S/N CE-929N3737UAirria Holdings LLC · BerlinBuilt 1980 · S/N ME-379N3738QLumpkin Ed · Rosie, ARS/N TE-305N3738RHumphries Scott A · Houston, TXBuilt 1980 · S/N E-1771N3738ZAma LLC · Port Orange, FLS/N E-1772N3739QN3739q LLC · Colleyville, TXFirst renewal noticeBuilt 1982 · S/N ME-378N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N373GTCruisaire Inc · Port Orange, FLBuilt 1957 · S/N D-5395N373LMAdkisson William C · Conway, ARBuilt 1969 · S/N TE-740N373STLassen Peter C · Ventura, CAS/N EA-308N373TBarker Philippe · San Leon, TXBuilt 1963 · S/N D-7138N373ZEvans Dale A · Green Cove Springs, FLBuilt 1960 · S/N D-6550N37402Viking Construction Inc · Hayden Lake, IDBuilt 1980 · S/N EA-165N3740BWood Graham A · Marshall, WIS/N WA-186N3741BCherokee Trail Aviation LLC · Tontitown, ARBuilt 1980 · S/N E-1722N3741COmr Investments LLC · Dawson, GABuilt 1980 · S/N E-1757N3743BPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1955 · S/N CH-169N3747QWolff Charles L · Pensacola, FLBuilt 1967 · S/N TE-307N3748QThoendel Jason · Saint Charles, MOBuilt 1967 · S/N D-8411N374TOtt James D · Kilgore, TXBuilt 1966 · S/N D-8165N374ZZulu Golf LLC · Yukon, OKBuilt 1960 · S/N D-6554N37533Dobie Aviation Ltd Co · Fayetteville, GABuilt 1975 · S/N TE-1063N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393N3755BYazdi Navid D · Beaverton, ORBuilt 1955 · S/N CH-195N3759QJ & C Companies LLC · Mesa, AZBuilt 1967 · S/N D-8394N375JWPanthers Aviation LLC · Pikeville, KYBuilt 1995 · S/N E-2918N375LMiroyan Robert Trustee · San Jose, CABuilt 1973 · S/N E-427N375RBMarinella Leasing LLC · Chandler, AZBuilt 1998 · S/N E-3155N3760BSavage David C · Austin, TXBuilt 1979 · S/N TC-2109N3762QHarris Randal Glenn · Sedona, AZS/N D-8398N3763QOrr Robert · San Clemente, CABuilt 1967 · S/N D-8399N376GTJohnson Michael G · Jasper, GABuilt 1976 · S/N M-1889N376RHSeckel Dean · Mount Vernon, WABuilt 1998 · S/N EA-612
Back to AD 99-05-13 R1 WD