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.

N2571HRiker Walter T · Anchorage, AKBuilt 1979 · S/N 18-7909200N2571PStrick Steffen G · Mc Grath, AKBuilt 1955 · S/N 18-4311N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938N2572MChieftain LLC · Hot Springs, ARS/N 12-941N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312N25730Orton Aviation LLC · Walker, MNBuilt 1940 · S/N 3690N25736Bauer Joachim · Rhome, TXBuilt 1939 · S/N 4819N2573JBusch Bruce K Trustee · Cerritos, CABuilt 1979 · S/N 18-7909132N2574AJones Daryl L · Spokane, WABuilt 1952 · S/N 22-866N25753Komin Steve C · Ingleside, ILBuilt 1939 · S/N 4-823N25755Graham Randall S · Mendota Heights, MNBuilt 1939 · S/N 3711N2576AChristopher Steven · Claremore, OKBuilt 1952 · S/N 22-868N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316N2577AHelms Michael R Sr · York, SCBuilt 1952 · S/N 22-869N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051N25783Tegtmeier Michael C · Watertown, WIBuilt 1939 · S/N 3738N2579ASharpe Matthew · Olympia, WABuilt 1951 · S/N 22-870N2579MBarela Peter A · Wasilla, AKBuilt 1946 · S/N 12-946N257AWWright Laura J · Hagerstown, MDS/N 12-3304N257TRegistration Pending · Pittsfield, MERegistration pendingBuilt 1953 · S/N 18-2371N25816Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1939 · S/N 3768N2581ASattler Philip J · River Falls, WIBuilt 1952 · S/N 18-2157N2581MSpencer David W · Anchorage, AKBuilt 1947 · S/N 12-1049N2581PWick Melvin D · Palmer, AKBuilt 1955 · S/N 18-4323N25822Duke Jimmy · Isola, MSS/N 3777N25824Healan Jack B Jr · Amelia Island, FLBuilt 1939 · S/N 3774N2582SHigh Exposure Inc · Wilmington, DEBuilt 1979 · S/N 18-7909161N25835Etheredge William T IV · Texas City, TXBuilt 1939 · S/N 3785N2583BManning James E · Puryear, TNBuilt 1941 · S/N 5-705N2583PHudzinski Thomas E · Wasilla, AKBuilt 1955 · S/N 18-4325N2583QDykstra Tony R · Pipestone, MNS/N 25-8056049N25844Koblenzer Fredric Matthais · Key Largo, FLBuilt 1939 · S/N 4-826N25846Cragg Gordon E · Georgetown, TXS/N 3794N2584PZambarano Matthew · South Hero, VTBuilt 1955 · S/N 18-4326N2584SStrouckel Jesse · Roscoe, SDS/N 18-7909162N25850Morey Airplane Co Inc · Middleton, WIBuilt 1939 · S/N 3796N2585ARipplinger Stephen M · Enderlin, NDS/N 18-2161N2585SWright George E · Homestead, FLS/N 18-7909164N25863Philips Joe C · Bryan, TXBuilt 1939 · S/N 3825N2586MSmith Randall A C · North Pole, AKBuilt 1946 · S/N 12-1047N25876Johnson Richard E · Duluth, MNBuilt 1939 · S/N 3826N2587JCastle Chad · Sunnyside, WABuilt 1979 · S/N 18-7909133N25880Rother Earle W III · Sunnyvale, CABuilt 1939 · S/N 3833N2588POkonek Kellie L · Girdwood, AKBuilt 1955 · S/N 18-4332N25894Old Style Aircraft LLC · Ellsinore, MOBuilt 1939 · S/N 3750N258TDiamond X LLC · Elko, NVBuilt 1953 · S/N 18-2372N2591HRaile Randall J · Benkelman, NEBuilt 1979 · S/N 18-8009003N2591MFlyer One LLC · Palm Harbor, FLBuilt 1946 · S/N 12-950N25927Cuddie Robert R · Marble Falls, TXBuilt 1939 · S/N 3873N2592PRogers Lee B · Anchorage, AKBuilt 1955 · S/N 18-4336
Back to AD 99-01-05 R1