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.

N4689ZDavis James J · Leonardtown, MDBuilt 1961 · S/N 22-8227N4690ZFialcowitz Thomas L · Hotchkiss, COBuilt 1961 · S/N 22-8228N4691THirsch Michael V · Cambridge, MABuilt 1959 · S/N 22-6713N4691YSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1967 · S/N 25-4422N4692HFerguson James L Jr · New Cambria, KSBuilt 1948 · S/N 17-90N4692YBillingsley Robin Trustee · Chugiak, AKBuilt 1971 · S/N 18-8952N4693YKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 25-4424N4694HWeber Stephen J · Hastings, MNS/N 17-92N4695MChalmers Ashley · Manalapan, NJS/N 11-204N4695YSnider Scott E DBA · Turner, MTBuilt 1973 · S/N 18-7309019N4697ZAntesberger Edward A · Fairfax, VABuilt 1961 · S/N 22-8237N4698HRegistered aircraftBuilt 1948 · S/N 17-96N4698MTri-County Sprayers Inc · Hamlin, TXBuilt 1947 · S/N 11-207N4699MCaloon John H · Greenfield, MABuilt 1947 · S/N 11-208N4699YSandhill Soaring Club Inc · Brighton, MIBuilt 1967 · S/N 25-4417N469JJTesmer Dean D · Rio, WIBuilt 1989 · S/N 1809030N46FPGarner Jerry L · Sugar City, IDS/N 12-249N46SCGravestock Jon W · Saint Maries, IDBuilt 1946 · S/N 12-990N4700MRobbins Richard A · Broomfield, COBuilt 1947 · S/N 11-209N4701HParker Newlan · Billings, MTS/N 11-490N4703AStromberg Gary J · Medicine Lake, MTS/N 18-4918N4703MCompton Doug · Morgan, UTS/N 11211N4703ZStarling Ronald A · Prescott, AZBuilt 1961 · S/N 22-8245N4704ZRegistration Pending · Canyon Country, CARegistration pendingBuilt 1961 · S/N 22-8246N4706HSnider Scott E · Turner, MTBuilt 1948 · S/N 11496N4706ZAirsmith Aviation LLC · Oshkosh, WIS/N 22-8248N4707ASherman Aviation Inc · Redmond, ORBuilt 1956 · S/N 18-4924N4707CSmith James A · Lyle, WABuilt 1955 · S/N 22-3291N4707HCoughlin Edward L · Cazenovia, NYBuilt 1948 · S/N 11-494N4707YWengair LLC · Powell, WYBuilt 1967 · S/N 25-4439N4707ZBradsher Larry Flint · Rougemont, NCBuilt 1961 · S/N 22-8250N4708AFranz Stanley · Yakima, WABuilt 1956 · S/N 18-4926N4709HLinse Kelly L · Plattsmouth, NEBuilt 1948 · S/N 11-497N4710MHerrick D E · Plymouth, MIRegistration revokedBuilt 1947 · S/N 11-219N4711MFolsom Aubrey C · Pelham, ALFirst renewal noticeBuilt 1947 · S/N 11-220N4711URussell Jeffrey P · Hampden, MES/N 11-130N4711ZHanna David A · Keene, TXS/N 22-8261N4712AProudfoot Ranches Inc · Ione, ORBuilt 1956 · S/N 18-4930N4712CPershing Todd Clark · Jacksonville, ORBuilt 1947 · S/N 12-3989N4712MMadariaga Scott A · San Diego, CABuilt 1947 · S/N 11-221N4712YGoldfarb Alice F · Conway, MABuilt 1971 · S/N 18-8955N4713HPreszler Joel R · Braddock, NDBuilt 1948 · S/N 11-501N4713ZFailing Amanda R · Wasilla, AKBuilt 1961 · S/N 22-8257N4714YSoukup Matthew J · Eagle River, AKS/N 18-8956N4715HMaxwell William P · Port Orange, FLS/N 11-503N4715MHandly W A · Arcola, MSBuilt 1947 · S/N 11-223N4715ZMuehlberg Stephen E · Newcastle, OKBuilt 1961 · S/N 22-8259N4716HRipplinger Paul P · Enderlin, NDBuilt 1948 · S/N 11-504N4716MMurray William H · East Jordan, MIBuilt 1947 · S/N 11-224N4717AOppegaard Craig E · Saint Louis Park, MNS/N 18-4935
Back to AD 99-01-05 R1