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.

N35277Uber James E · Sanborn, NYBuilt 1941 · S/N 5-594N35279Registration Pending · North Hampton, NHRegistration pendingBuilt 1941 · S/N 5-597N3527ASteinhoff Aaron M · Ethel, WABuilt 1953 · S/N 22-1799N3527MMisinco Michael H · Macon, GABuilt 1947 · S/N 12-2371N35280Hoffman Steven L Trustee · Nokomis, ILBuilt 1941 · S/N 5-598N35283Maynard Marc L · Dartmouth, MAS/N 5-601N35288Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-605N3528ASmith Carl D · Wilson, WIBuilt 1953 · S/N 22-1800N3528MPierce Nathan · Holton, MIS/N 12-2372N3528PSalerno Joseph C Jr · Gettysburg, PABuilt 1955 · S/N 22-3283N35290Dougherty Robert E · Mosheim, TNBuilt 1941 · S/N 5-608N35297International Air Services Inc Trustee · Carson City, NVFirst renewal noticeS/N 5-616N35298Lawson Larry · Morgantown, WVBuilt 1941 · S/N 5-618N35305Kopaska Kelly J · Guthrie Center, IABuilt 1941 · S/N 6271N3530PYaroslavski Limited Partnership · Norman, OKBuilt 1955 · S/N 22-3286N3531AHirkala Ronald R · New Cumberland, WVS/N 22-1803N3531MBorder James H · Weiser, IDBuilt 1947 · S/N 12-2375N35327Kurtz Daniel · Circleville, OHBuilt 1941 · S/N 6293N35328Virga LLC · Sharon Springs, KSS/N 6295N3532MToth Richard C · Tinley Park, ILS/N 12-2376N3532PBryan Curtis L · Enumclaw, WABuilt 1955 · S/N 22-3287N3532ZMurphy Michael R Trustee · Syracuse, NYBuilt 1960 · S/N 22-7437N35335Grogan Edward V III · Blasdell, NYBuilt 1941 · S/N 6302N3533AKilpatrick John N · Redding, CABuilt 1953 · S/N 22-1805N3533ZSchwanebeck Derek D · Ellsworth, NEBuilt 1960 · S/N 22-7438N3534AZimmerman Kenneth E · Eugene, ORBuilt 1953 · S/N 22-1806N3534EFox Christopher K · Hanover, PABuilt 1941 · S/N 6309N3535ADepoy Lowell K · Salem, INBuilt 1953 · S/N 22-1807N35374Phelan Ricky R · Jefferson, ORBuilt 1941 · S/N 5-625N3537MWade Mark C · Bonham, TXBuilt 1947 · S/N 12-2100N35380Saxton William S · Yarmouth Port, MABuilt 1941 · S/N 5629N35381Pss Air Inc · Middlesboro, KYS/N 5-630N3538PMachovsky Andrew J · Mesa, AZBuilt 1955 · S/N 22-3294N3538ZEllis Grover D · San Ford, NCBuilt 1960 · S/N 22-7445N35393Maga Montana LLC · Kalispell, MTS/N 5-644N35394Acs Aviation LLC · Burlington, VTBuilt 1941 · S/N 5-643N3539PAdkins Clinton R · Corvallis, MTBuilt 1955 · S/N 22-3295N353DBStroud Jerry L · Hope, ARBuilt 1940 · S/N 4654N35400Aero Maintenance Inc · Vancouver, WAS/N 5-650N35409Sandvik Randall L · Palmer, AKBuilt 1941 · S/N 5-660N35412Whitley Brett A · Montgomery, TXBuilt 1941 · S/N 5-663N35413Piper Cub J5a LLC · Westford, MABuilt 1941 · S/N 5664N35415Irving Kyle P · Wasilla, AKS/N 5-666N35417Classic Aircraft Restoration LLC · Gladstone, MIBuilt 1941 · S/N 5-668N3541MPhillips Alan Roger · Anchorage, AKBuilt 1947 · S/N 12-2388N3541PZang Peng · Mason, MIBuilt 1955 · S/N 22-3297N35424Terkeurst William J IV · Gurley, ALBuilt 1941 · S/N 5-675N35428Reseigh Bracken John · Wasilla, AKBuilt 1941 · S/N 4-1388N3542MRobertson Keith A · Wasilla, AKBuilt 1947 · S/N 12-2099N35444Schmidt Richard E · Fort Myers, FLBuilt 1941 · S/N 6349
Back to AD 99-01-05 R1