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.

N30SFN2wr LLC · Cincinnati, OHBuilt 1956 · S/N D-4832N30SLAppel Neal C · Prescott, AZBuilt 1972 · S/N E-338N30VMKnott Richard C · Stony Brook, NYBuilt 1973 · S/N CE-453N30VTPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1973 · S/N D-9439N30WGMather Christopher D · Hayward, CABuilt 1974 · S/N TE-997N3100BLeone James Frank · Cotulla, TXBuilt 1994 · S/N CE-1789N3101WGeorge Jon A · Durango, COS/N TE-953N3102CD & D Motors LLC · Georgetown, TXBuilt 1987 · S/N CE-1179N3102WBonanza Leasing LLC · Versailles, KYBuilt 1973 · S/N D-9558N3105WDavis Kenneth D · Ft Wayne, INBuilt 1973 · S/N E-494N3106DSouth Delta Aviation Inc · West Helena, ARBuilt 1988 · S/N CE-1215N31074Hale Aviation Inc · Saint Augustine, FLBuilt 1988 · S/N CE-1210N31075Camden Group Inc · Boston, MABuilt 1988 · S/N E-2415N3108LWickersham Brian L · Council Bluffs, IABuilt 1988 · S/N CE-1248N3108NBartlett Paul H · Nebo, NCBuilt 1988 · S/N CE-1218N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400N3109WIII Per LLC · Lewes, DEBuilt 1973 · S/N TE-955N310TVHaushold Aviation LLC · Shelbyville, TNBuilt 1978 · S/N E-1340N3110ATalon Group LLC · Marietta, GABuilt 1979 · S/N TC-2207N3111Setter Thomas D · Burnsville, MNBuilt 1953 · S/N A-964N3111DMonarch Air Services LLC · Ballwin, MOBuilt 1994 · S/N E-2874N3111HMcniel George A · Portland, ORBuilt 1987 · S/N CE-1168N3111JAir Arkansas Inc · Wilmington, DEBuilt 1987 · S/N CE-1192N3111WChubb Oil & Gas LLC · Missoula, MTBuilt 1967 · S/N D-8573N31121Full Flaps 2 LLC · Peachtree City, GABuilt 1988 · S/N E-2428N3112XRichards Timothy T · Sherborn, MABuilt 1988 · S/N CE-1220N3112YWykoff Donald W · West Chester, OHBuilt 1988 · S/N E-2410N3113GChristiansen Thad Charles · Spring Grove, ILBuilt 1988 · S/N CE-1252N3113NTorgerson Glenn Allen · Snohomish, WABuilt 1988 · S/N CE-1250N3113VMurrell Louis B · Wichita, KSS/N D-535R6N31143Mjj Aircraft Inc · Wilmington, DEBuilt 1988 · S/N E-2443N3114YN635v LLC · Nacogdoches, TXBuilt 1988 · S/N E-2441N3115WBenson James M · Cleveland, TNBuilt 1973 · S/N E-497N3116WMathis Bettina Jary · Dripping Springs, TXBuilt 1973 · S/N E-499N3119TRiverwind Strategic Solutions LLC · Lewes, DEBuilt 1994 · S/N E-2878N311ANValiair Ltd Co Trustee · Casper, WYBuilt 1970 · S/N P-141N311BLawrence Guy A · Bakersfield, CABuilt 1955 · S/N D-4424N311BGBluffton Flying Service Ltd · Bluffton, OHBuilt 1971 · S/N D9276N311CHWings Of Eaglz LLC · Lamoni, IAS/N TK-149N311CTShahriari David B · Anaheim, CABuilt 1976 · S/N E-853N311DDSierra Aeronautics LLC · Gambier, OHBuilt 1960 · S/N DH-311N311FTR&D Land And Air LLC · St Simons Is, GABuilt 1964 · S/N TC-744N311JWBonanza 311 Jw Limited · Urbandale, IABuilt 1959 · S/N D-5925N311MWS S Euroflyer III Ltd · Wilmington, DEBuilt 1987 · S/N CE-1155N311NSimmons Calvin L · Peralta, NMBuilt 1970 · S/N P-130N311PGKumar Shekar · Greenwood, SCBuilt 1999 · S/N E-3257N311PJArras Leonard D · Canal Fulton, OHBuilt 1987 · S/N CE-1132N3120MCowtown Aviation LLC · Aledo, TXBuilt 1987 · S/N CE-1204N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645N3121CUnkefer Edward Lowell · Waynesboro, VAS/N E-2404
Back to AD 99-05-13 R1 WD