OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N156TSale Reported · Casselton, NDSale reported, canceledBuilt 1953 · S/N 18-2270N1573AHanson Scott F · Grantsburg, WIBuilt 1951 · S/N 20-803N1576AHile Adam V · Apple Creek, OHBuilt 1951 · S/N 20-790N1577AYoung Carl J · Lubbock, TXBuilt 1951 · S/N 20-812N1577PPaulson Dean S · Eagle River, AKBuilt 1954 · S/N 18-3740N1579ADelap Jay · Collinsville, OKBuilt 1951 · S/N 20-813N157GWFoster Colt D · Eagle River, AKBuilt 1957 · S/N 18-6182N157PJCarnighan Kelly · New Albany, INBuilt 1946 · S/N 12-1152N157SCStone William E · Cusick, WABuilt 1957 · S/N 18-5997N157TMccray B F Jr · Manchester, OKBuilt 1953 · S/N 18-2271N1580ADenton David W · Cedaredge, COS/N 20-814N1580PBltyhe Anne T · Paso Robles, CAS/N 183743N1588PWar Eagles Air Museum · Santa Teresa, NMBuilt 1954 · S/N 18-3751N1589AWilliams Richard P · Sheldon, WIS/N 20-824N158FJN3955b Corp Trustee · Wilmington, DEBuilt 1965 · S/N 18-8312N1590AChapman Dan W · Soldotna, AKBuilt 1951 · S/N 20-826N1590PForgey Carl · Petersburg, AKBuilt 1954 · S/N 18-3755N1591AKlein Frank J · Riley, KSBuilt 1951 · S/N 20-827N1592ABurbank Kevin L · Boscawen, NHS/N 20-829N1592PFerguson Robert C · Cornelia, GABuilt 1954 · S/N 18-3757N1596AMinelli Giovanni · Carmel, CABuilt 1951 · S/N 20-835N1596PPassmore Aviation LLC · Claremore, OKS/N 18-3761N1597PStokes Letta J · Chugiak, AKBuilt 1954 · S/N 18-3762N1598AEllis Hal R · Colorado Springs, COBuilt 1952 · S/N 20-836N1599APetro Harold J · Des Moines, IABuilt 1952 · S/N 20-841N1599PSnowden Robert W · Mason, TXBuilt 1954 · S/N 18-3764N159AWLutz Robert J · Mount Victory, OHBuilt 1978 · S/N 18-7809035N159TGumley Titus G · Wasilla, AKBuilt 1953 · S/N 18-2273N15ADDurrent Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18-7809065N15JKCaskey Martin K · Paso Robles, CABuilt 1946 · S/N 12-265N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814N15XXDalks Leasing Inc · Wilmington, DEBuilt 1951 · S/N 18-811N1602ABent James L Jr DBA · Palatine Bridge, NYS/N 18-1240N1602PDavis Jacob J · Georgetown, TXBuilt 1954 · S/N 22-2417N1604AFredericks Elmo J · Mandaree, NDBuilt 1951 · S/N 18-1242N1606AFilkill David B · Willow, AKBuilt 1951 · S/N 18-1246N160CWAbraham Elizabeth J · Browntown, WIBuilt 1950 · S/N 18-343N160HLProbasco Mitchell L · Floydada, TXBuilt 1946 · S/N 12-1636N160KPWorman Clinton L · Volborg, MTBuilt 1954 · S/N 22-2422N160PCMeggers Roger D · Baker, MTS/N 18-7709094N160WMSirvelis Aras J · Anchorage, AKBuilt 1977 · S/N 18-7709077N1610ABauder Robert J · Soldotna, AKBuilt 1951 · S/N 18-1252N1611AJones William Ransom · Anchorage, AKBuilt 1951 · S/N 18-1251N1611CNorthern Flyway LLC · Anchorage, AKBuilt 1954 · S/N 18-3393N1611PBoyer Scott C · Custar, OHBuilt 1954 · S/N 22-2425N1612AGlover Thomas B · Marana, AZS/N 18-1253N1612LKutilek Emil J · Charlottesville, VAS/N 188620N1616POwen David C · Fort Myers, FLBuilt 1954 · S/N 22-2430N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263
Back to AD 99-01-05 R1