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.

N78561Gayler Larry · Thermal, CABuilt 1947 · S/N 12-2645N78564Damico Anthony R · Anchorage, AKBuilt 1947 · S/N 12-3939N78565Sousa Gerald L · Talkeetna, AKBuilt 1947 · S/N 12-3940N78567Frazier Forrest Alan · Taylors, SCS/N 12-3942N7856HPratt John Jr · Anchorage, AKBuilt 1946 · S/N 12-757N78570Van De Mark Raymond L · Ithaca, NYS/N 12-3945N78573Hohmann Courtney P · Jacksonville, FLBuilt 1947 · S/N 12-3949N78574Johns Robert A · Anchorage, AKBuilt 1947 · S/N 12-3950N78575Hoppe Nicholas J · Big Lake, AKBuilt 1947 · S/N 12-3951N7857DHeinze Bill · Ashley, MIBuilt 1957 · S/N 22-5507N7857HCompton Delmer Dale Jr · Pocahontas, ILBuilt 1946 · S/N 12-758N78580Ferley Shane M · Goddard, KSBuilt 1947 · S/N 111373N78581Weber Jacob H · Hartford, WIS/N 12-3967N78582Gibbs Luther A · Fremont, OHBuilt 1947 · S/N 12-3968N78586Krup Inc · Milligan, NEBuilt 1947 · S/N 12-3972N78588Mackey Jacob E · Big Piney, WYS/N 12-3957N78589Sanstead Peter N · Tulsa, OKBuilt 1947 · S/N 12-3956N7858DRegistration Pending · Raleigh, NCRegistration pendingBuilt 1957 · S/N 22-5508N78594Pyne James L · Streator, ILFirst renewal noticeS/N 12-3975N78597Borgerson Mark · Montevideo, MNBuilt 1947 · S/N 12-3960N7859DMurray Craig W · Raymond, WABuilt 1957 · S/N 22-5509N7859HSly Duane D · Platte, SDBuilt 1946 · S/N 12-760N78601Leonard James P · Eagle River, AKBuilt 1947 · S/N 11-1367N78602Slayden Steven M · Rhome, TXBuilt 1947 · S/N 11-1361N78605Tuffli David L · Hillsboro, ORBuilt 1947 · S/N 11-1364N78608Zimmerman Shawn A · Kalispell, MTBuilt 1947 · S/N 11-1368N7860HCrockett Donald Richard · Artesia, NMBuilt 1946 · S/N 12-761N78610Smith Brant P · Palmer, AKS/N 11-1370N78611Anderson James W · Kennebec, SDBuilt 1947 · S/N 11-1371N78613Martin James D · Graford, TXBuilt 1947 · S/N 11-1374N78615Nyberg Randall L · Polk City, IABuilt 1947 · S/N 11-1376N78619Jones Marlo J · Kent, WABuilt 1947 · S/N 11-1380N7861DBarnes Rebecca · Anchorage, AKBuilt 1957 · S/N 18-6010N78620Toombs George E Jr · Canton, TXBuilt 1947 · S/N 11-1381N78629Fontenot Jeffery W · Granbury, TXBuilt 1947 · S/N 11-1390N7862PScenic Mountain Air Inc · Moose Pass, AKBuilt 1962 · S/N 18-7873N78630Krier Marc A · Ashland, KSBuilt 1947 · S/N 11-1391N78632Ginther Michael P · Lemmon, SDBuilt 1947 · S/N 11-1393N78633Wells Kris G · Barron, WIS/N 11-1394N78635Horn Adriane L · Kodiak, AKBuilt 1947 · S/N 11-1396N78636Rovegno Paul C II · Burlington, NCS/N 11-1397N7863DStevenson Ben L · Talkeetna, AKS/N 18-6012N78641Metz Daniel J · Brighton, COBuilt 1947 · S/N 11-1402N78648Zielinski Dustin K · Salem, ORBuilt 1947 · S/N 11-1410N7864HDevil Dusters Inc · Artesia, NMS/N 12-767N78653Rhiley Craig J · Oshkosh, NEFirst renewal noticeBuilt 1947 · S/N 11-1414N78654Jorgenson Brian K · Sandpoint, IDBuilt 1948 · S/N 11-454N78656Petersen Gary L · Walton, NEBuilt 1947 · S/N 11-1417N78659Pearce David E Jr · Lancaster, CAS/N 11-1420N7865DLrh Equipment LLC · Pendleton, ORBuilt 1957 · S/N 18-6014
Back to AD 99-01-05 R1