OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N5890DCouey Robert H · Anchorage, AKS/N 18-5315N5890LSturgeon Kenneth V · Winter Garden, FLBuilt 1972 · S/N AA5-0240N5890QDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1965 · S/N 3153N5890UKempton Lana Julia Trustee · Douglasville, GABuilt 1970 · S/N 28-26786N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508N5891DRiggs J'Ann · Wasilla, AKBuilt 1956 · S/N 18-5318N5891LAlldridge Thomas H · Cochranville, PABuilt 1972 · S/N AA5-0091N5891RTun Bay Inc · Wasilla, AKBuilt 1966 · S/N 17253560N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394N5892UFeighl Engineering Group Inc · Hot Springs, ARS/N 28-26735N5893LHegwood Jonathan E · Petal, MSBuilt 1972 · S/N AA5-0093N5893UCasper Gary · Spring Creek, NVBuilt 1970 · S/N 28-26706N5893WFinch Howell M Jr · Victoria, TXBuilt 1965 · S/N 28-2645N5894LTrueblood Terry L · Effingham, ILBuilt 1972 · S/N AA5-0094N5894QBlech Fritz · Grants Pass, ORBuilt 1965 · S/N 3155N5895LWatkins Marion D · Mcdonough, GABuilt 1972 · S/N AA5-0095N5896UGift Academy Inc · Vernon, TXS/N 28-26792N5897LCulver Christopher J · Rockmart, GABuilt 1972 · S/N AA5-0097N5898LLamer Benjamin W · Ada, MIBuilt 1972 · S/N AA5-0098N5898QO'Neal Timothy L · Damascus, ORBuilt 1965 · S/N 3157N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213N5898WFrazier Justyn K · Mesa, AZS/N 28-2708N589CBBryan Curtis · Enumclaw, WAS/N 589N589RAMcgowin James E · Ball Ground, GABuilt 2007 · S/N 60589N589TRRussell Tony B Jr · Severance, COBuilt 1975 · S/N 589N58AEKraujales Adam M · East Moriches, NYS/N 28-5075N58BWarnick Ronald S · Cascade, MTBuilt 1968 · S/N 15068409N58BFH Jack Flash Inc · Fort Worth, TXS/N 12013N58BGStassi Jean-Paul A Jr · Henagar, ALS/N 312N58DSBalliet Edgar J III · Northampton, PABuilt 1979 · S/N 17272305N58GMWanless Dax D · Granite Falls, MNS/N 153N58JPThompson Frank L · Weiser, IDBuilt 1977 · S/N 002N58JSMcmillin Christopher W · Tucson, AZS/N 954N58KFrantz Douglas M · Mustang, OKBuilt 1979 · S/N 1067N58LElliott John O · Lathrop, MOFirst renewal noticeBuilt 1966 · S/N 1N58LRRush Hal Lee Jr · Oneonta, ALBuilt 1965 · S/N 2942N58SCCragg Philip A · Point Roberts, WAS/N 849N58TYJohnson Jake M · Texarkana, TXBuilt 1977 · S/N 17270111N58YMTailwind Partners LLC · Valparaiso, INBuilt 1967 · S/N 28-4515N5900JAir America LLC · Sioux Falls, SDS/N A1500200N5901QSpringer Jesse J · Avon, MNBuilt 1965 · S/N 3160N5902WWald Charles E · Greenwood, MOBuilt 1965 · S/N 28-2752N5903QPressley Brent DBA · Morristown, TNBuilt 1965 · S/N 3186N5903WCluff Benjamin · Meridian, IDBuilt 1965 · S/N 28-2967N5904UGilded Gull Aviation LLC · Middletown, RIBuilt 1970 · S/N 28-26891N5904WReinhart Adam R · Courtland, MNBuilt 1965 · S/N 28-2699N5905QWainwright Mitchell J · Saint Charles, MOBuilt 1965 · S/N 3161N5906WGjj LLC · Kalispell, MTBuilt 1965 · S/N 28-2814
Back to AD 79-10-03 R2