OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-R1')
    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-01-05-R1')
  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.

N287TMiller Timothy P · Anchorage, AKBuilt 1953 · S/N 18-2401N2880MAbalama Arthur C · Bethel, AKBuilt 1946 · S/N 12-1309N2880PSaalsaa Brad · Ketchikan, AKBuilt 1955 · S/N 18-4477N2882ZKroner David S · Rock Creek, OHBuilt 1959 · S/N 18-7044N2883MRegistered aircraftBuilt 1946 · S/N 12-1423N2883ZFoster Gary E · Kress, TXBuilt 1959 · S/N 18-7045N2884PRocky Creek Jbd Inc · Boca Grande, FLBuilt 1955 · S/N 18-4481N2885PLeprechaun Air Service Inc · Syracuse, KSBuilt 1954 · S/N 18-4482N2886PBurg Mark S · Powell Butte, ORBuilt 1955 · S/N 18-4483N2886ZNettles William C · Soldotna, AKBuilt 1959 · S/N 18-7059N2887PGoldberg Aviation · Cody, WYBuilt 1955 · S/N 18-4485N2887ZElliott Robert M · Sweetwater, TXBuilt 1959 · S/N 18-7060N2888MLapoint Daniel L Jr · Bellevue, MIBuilt 1946 · S/N 12-1426N2889ZPeters Thomas K · Wasilla, AKBuilt 1959 · S/N 18-7066N288NYHrutkay Charles S · Scenery Hill, PAS/N 18-868N288TBecker James · Torrington, WYBuilt 1953 · S/N 18-2402N2891PHula Jesse M · Anchorage, AKBuilt 1956 · S/N 18-4489N2892MFoster Randy · La Grange, TXBuilt 1947 · S/N 12-1311N2892ZDykema Richard H · Soldotna, AKBuilt 1959 · S/N 18-7075N2893POaero LLC · Boise, IDBuilt 1955 · S/N 18-4491N2894PHolmes Dallas Wade · Bend, ORBuilt 1955 · S/N 18-4492N2894ZRs Specialties LLC · Anchorage, AKBuilt 1959 · S/N 18-7078N2895PDawes Donald E · College Place, WABuilt 1955 · S/N 18-4493N2897ZFurney Albert · Big Lake, AKBuilt 1959 · S/N 18-7083N2898MPutman John Vick · San Antonio, TXBuilt 1946 · S/N 12-1434N289TMahan Tyler J · King Salmon, AKFirst renewal noticeBuilt 1953 · S/N 18-2403N2900PBurns Travis S · Central Point, ORBuilt 1955 · S/N 22-3163N2900ZCheatham Paul · La Verne, CABuilt 1959 · S/N 22-6868N2901MRickard William A · Virginia Beach, VABuilt 1946 · S/N 12-1325N2901ZSmith Roger L · Los Alamos, NMBuilt 1959 · S/N 22-6873N2902MKelsey Michael O · Carey, IDBuilt 1946 · S/N 12-1362N2902PHentgen Chip · Peru, INBuilt 1955 · S/N 22-3168N2903MKrog Steven L · Hartford, WIBuilt 1946 · S/N 12-1327N29042Stevann Farms Ltd · De Witt, IABuilt 1940 · S/N 6013N2904MLange Keith J · Wasilla, AKBuilt 1946 · S/N 12-1318N2905PSimpson Danny R · Waunakee, WIBuilt 1955 · S/N 22-3172N2906MFry Steven G · Eagle River, AKBuilt 1946 · S/N 12-1321N2907MKutschera Thomas C · Youngsville, NYBuilt 1946 · S/N 12-1322N2907PWickenheiser John D · Newport, MIBuilt 1955 · S/N 22-3175N2908PHull Mahlon B · Sedro Woolley, WABuilt 1955 · S/N 22-3176N2910MEkdahl John Edward · Freehold, NJBuilt 1946 · S/N 12-1436N2912PJackson Robert S · Gallatin, TNBuilt 1955 · S/N 22-3180N2912ZFord Charles D · Clifton, TNBuilt 1959 · S/N 22-6882N2913MMccay Brian D · Earlysville, VABuilt 1946 · S/N 12-1444N2914MPannone Steven R · Palmer, AKBuilt 1947 · S/N 12-1334N2914PPerreault Guy · Newbury Park, CABuilt 1955 · S/N 22-3182N2914ZEarle Russell John · Reno, NVBuilt 1959 · S/N 22-6884N2916MBradford Murvin L · Hensley, ARS/N 12-1417N2917PRegistered aircraftBuilt 1955 · S/N 22-3185N2917ZRegistration Pending · Granby, MORegistration pendingBuilt 1959 · S/N 22-6887
Back to AD 99-01-05 R1