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.

N3910ARzepka Rick · Solon, OHBuilt 1970 · S/N D-9093N3914APlane Jane Aviation LLC · Sylvania, GABuilt 1970 · S/N TE-789N391HHalla David M DBA · Tuscola, TXBuilt 1962 · S/N JH-164N391SAndrews Patrick D · Neosho, MOBuilt 1970 · S/N TC-1095N391ZKeene Keith · Houston, TXBuilt 1960 · S/N D-6558N39286Mead Kassandra · Alpine, TXBuilt 1960 · S/N TD-370N392BBowling Gregory · Floresville, TXBuilt 1957 · S/N D-5282N392SPlocher Corey · Port Orchard, WABuilt 1968 · S/N D-8752N3932ASims Douglas · Naples, FLBuilt 1953 · S/N 53-4117AN393TIronhawk Aviation LLC · Indianapolis, INBuilt 1963 · S/N D-7166N39474Hartwig Aircraft Fuel Cell Repair Inc · St AndrewsBuilt 1966 · S/N MB-23N394EALavallee-Houston Anne-Marie M · Cape Coral, FLBuilt 2005 · S/N E-3594N394MCRegistered aircraftBuilt 1969 · S/N TE-755N394TAikens George · Greeley, COS/N TC-854N3952ARegistered aircraftBuilt 1969 · S/N D-9090N3954AVasil Christopher J · Los Gatos, CABuilt 1970 · S/N CE-308N3957ARegistration Pending · Denton, TXRegistration pendingBuilt 1970 · S/N D-9186N3958AHinton Richard D · Colleyville, TXBuilt 1970 · S/N D-9194N395KBBunn Mary · Williamstown, WVBuilt 1982 · S/N P-592N395SAFmco Promotions Inc · North Little Rock, ARBuilt 2000 · S/N E-3313N395ZSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1960 · S/N D-6566N396BSpring Creek Financial Inc · Lewistown, MTBuilt 1992 · S/N EA-537N396PMHansen Donald · Big Lake, MNBuilt 1963 · S/N D-7195N397AWPapa Tango Aviation LLC · Kalispell, MTBuilt 1980 · S/N TJ-207N397DFolse Michael John · San Jose, CABuilt 1968 · S/N TC-1109N397RCRegistered aircraftBuilt 1978 · S/N MC-631N3984Epstein Steven D · Vallejo, CABuilt 1970 · S/N P-147N398CBone Randall E · Weatherford, TXBuilt 1958 · S/N D-5571N398EPJg'S Mallardaire LLC · Benton, ARBuilt 1982 · S/N E-2029N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406N398TWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1976 · S/N E-976N3991AJohnson Douglas H · Rockwall, TXBuilt 1970 · S/N CE-315N3993NBeck Larry A · Arkdale, WIS/N D-2237N399BWilliams Jack J · Jasper, GABuilt 1957 · S/N D-5009N399CAHoman Mark A · Wake Forest, NCBuilt 1988 · S/N EA-478N399LT5280 High Corp · Wilmington, DEBuilt 1962 · S/N D-6951N399MCRegistered aircraftBuilt 1975 · S/N TC-1852N399PTDethomas John V Trustee · Boise, IDBuilt 1968 · S/N D-8727N399TABeattie Richard N Trustee · Anacortes, WABuilt 2000 · S/N E-3311N39ADRobbins William Clark · Anchorage, AKBuilt 1972 · S/N E316N39JBHarvey Hath R · Lubbock, TXBuilt 1988 · S/N CE-1233N39PJMeister Kurt · Mesa, AZBuilt 1979 · S/N P-514N39PRAeroplanes LLC · Cary, NCBuilt 1965 · S/N TE-23N39RHOlympic View Aircraft LLC · University Place, WABuilt 1977 · S/N TE-1113N39TASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N MC-230N39TCPutnam Larry Paul · Tucson, AZBuilt 1979 · S/N E-1486N39TFFountain Timothy E · Miami Beach, FLBuilt 1976 · S/N CE-636N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N39TPAnderson Robert K · Cleveland, TNBuilt 1969 · S/N TE-780
Back to AD 99-05-13 R1 WD