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.

N1690PPritchett Michael L · Benton, ARS/N 22-2476N1691AChase 13 LLC · Wilmington, DEBuilt 1952 · S/N 22-448N1691PTomporowski Robert C · Mahwah, NJS/N 22-2477N1692AAdams Steve W · Ranger, TXBuilt 1952 · S/N 22-444N1692PHoffmeyer Ronald P · Rapid City, SDFirst renewal noticeBuilt 1954 · S/N 22-2478N1693AHarp Kenneth F · Lake Geneva, FLFirst renewal noticeBuilt 1952 · S/N 22-449N1697PConnolly Joseph III · Redding, CABuilt 1954 · S/N 22-2483N1698PJobe Kevin D · Sutton, AKBuilt 1954 · S/N 22-2484N169ABSouthern Cub And Aircraft Restoration LLC · Pensacola, FLBuilt 1968 · S/N 25-4517N16MBLancaster Wesley A · Saint Augustine, FLBuilt 1961 · S/N 22-8387N16REFly Pnw LLC · Maple Valley, WAS/N 22-6518N1701ACirri Joseph A · Deming, NMBuilt 1952 · S/N 18-1288N1701PRegistration Pending · Walla Walla, WARegistration pending, pending cancellationS/N 22-2488N1703PCastillo Stephen P · San Antonio, TXBuilt 1954 · S/N 22-2490N1706BWagstrom Wayne A · Aurora, UTFirst renewal noticeS/N 12-1562N1707AParent Mark C · Blue Eye, MOBuilt 1952 · S/N 22-459N17080Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-7196N1708PRaymond Harrison Donald · Camp Verde, AZBuilt 1954 · S/N 22-2495N170TStoltzfus Sandra · Kidron, OHBuilt 1945 · S/N 18-2284N170WTBarber Shane C · Willow, AKS/N 12-753N1714BGreat Plains Aero Inc · Tolley, NDBuilt 1976 · S/N 18-7609109N1716AJacobs Dennis D · North Loup, NEBuilt 1952 · S/N 22-462N1716PJones Gary L · Kerrville, TXBuilt 1954 · S/N 22-2506N1717ARound Engine Aero · Nashville, MIS/N 22-466N1718PMorris Christian A · Hood River, ORBuilt 1954 · S/N 22-2508N1723PQuinn Michael · Matthews, NCS/N 22-2513N1724AMiller Billy E Sr · Dewitt, ARBuilt 1952 · S/N 22-482N1726PSimonsen Joshua A · White Salmon, WABuilt 1954 · S/N 22-2516N1727PBaker Geoffrey D · Philomath, ORBuilt 1954 · S/N 22-2517N1728PHanft Alan K · Twentynine Palms, CABuilt 1954 · S/N 22-2518N172TMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1953 · S/N 18-2286N1730PHolbrook Jonathan L · Morehead, KYS/N 22-2520N1731PLambert Wayne C · Canyon Lake, CABuilt 1954 · S/N 22-2521N1736PRegistered aircraftBuilt 1954 · S/N 22-2526N1738ALyall Gregory S · Anchorage, AKS/N 18-1311N1740ABlair Philip S · Fowlerville, MIBuilt 1952 · S/N 22-477N1741PWright Russell W · Ocala, FLBuilt 1954 · S/N 22-2531N1748PHarbison Robert L · Willow, AKBuilt 1954 · S/N 22-2539N1750PWeinreis Gene · Golva, NDBuilt 1954 · S/N 18-4069N1752PPurdy Ranch LLC · Buffalo, WYBuilt 1954 · S/N 18-4072N1754ASchrock Jaden D · Sterling, AKS/N 18-1319N1754PLorring Eric H · Kodiak, AKS/N 18-4074N1755ASchultheis John U · Wasilla, AKBuilt 1952 · S/N 18-1314N1755PBryan Edgar A II · North Pole, AKS/N 18-4075N1757MAdventurous LLC · Hayden, IDBuilt 1957 · S/N 18-6009N1757PJolin Mitchell S · Eagle River, AKBuilt 1954 · S/N 18-4077N1759AHargus Betty R · Fort Stockton, TXS/N 18-1325N1759MRud Dylan A · Clara City, MNS/N 4887N1759PFrank Daniel M · Kasilof, AKBuilt 1954 · S/N 18-4079N175WMyrick Charles Henry · Maryville, MOBuilt 1956 · S/N 22-3910
Back to AD 99-01-05 R1