OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N777VAVolante Aircraft LLC · South Jordan, UTBuilt 1980 · S/N 1N777VPFlightwing Equipment Corp · Beverly Hills, CABuilt 1974 · S/N 28-7415632N777VXGutierrez Ruben E · Fontana, CABuilt 1968 · S/N 28-24298N777WBClark Lloyd E · Hanover, MDBuilt 1973 · S/N 28-7305219N7780DMathews Development Co Inc · Santa Rosa Beach, FLBuilt 1957 · S/N 18-5969N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480N7780YKeller Zachary T · Wasilla, AKBuilt 1962 · S/N 18-7886N7781DCraig Adam J · Anchorage, AKBuilt 1957 · S/N 18-5970N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481N7781NKns Asset Management LLC · Lumberton, TXBuilt 1968 · S/N 28-5229N7782WDavies Kenneth A · Oak Harbor, WABuilt 1964 · S/N 28-1789N7783NForbes Aviation LLC · Boise, IDBuilt 1968 · S/N 28-5231N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484N7784WHarding Robert L · Nine Mile Falls, WABuilt 1964 · S/N 28-1792N7785NMorning Aviation LLC · Altoona, PABuilt 1968 · S/N 28-5232N7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeBuilt 1970 · S/N 17259486N7786NPearson Derek E · Rockwell City, IABuilt 1969 · S/N 28-5233N7786WRoger Dodger Vector Victor LLC · Fort Myers, FLBuilt 1964 · S/N 28-1794N7787NBarker Lynn Harvey · Sylmar, CABuilt 1969 · S/N 28-5235N7788MMcreynolds Michael A · Sikeston, MOBuilt 1974 · S/N 20-0022N7788NZwickel Claire · Catskill, NYBuilt 1968 · S/N 28-5236N7788PEight Eight Papa Inc · Williamsport, PABuilt 1962 · S/N 24-3005N7788VMaltenfort Andrew J · Culpeper, VABuilt 1970 · S/N 700055N7788WRichards Adam R · Mesa, AZBuilt 1964 · S/N 28-1797N7789CCasady Joseph P · Buckley, WABuilt 2024 · S/N JA2112176N7789MRipato Peter A · Maysville, KYBuilt 1974 · S/N 20-0023N7789NAntaya Adam N · Lakeland, FLS/N 28-5237N7789PS R Smith Ranch · Utopia, TXS/N 18-7835N7789WNguyen Tu K · Huntington Beach, CAS/N 28-1798N778JJGentry Marc E · Pearland, TXBuilt 1979 · S/N AA5B1166N778MFlores Ted A · Rio Rancho, NMBuilt 2004 · S/N 70432N778MBFredborg Matthew Alan · American Canyon, CABuilt 2002 · S/N 24276N778MRSpitzer Helicopter LLC · Woodland Hills, CABuilt 2001 · S/N 3201N778MWBaty Mark S · Napa, CABuilt 1975 · S/N M-1679N778RDKilo Golf Aviation LLC · St Simons Island, GABuilt 1976 · S/N 17702550N778RVIm Pruv All Inc · Fallon, NVBuilt 2001 · S/N 101N778ZJames Bryson Scott · Wasilla, AKBuilt 1961 · S/N 18-7656N7790DHeinrich Kerry Lynn · Meadow Vista, CABuilt 1957 · S/N 18-5992N7790NSchmid Daniel J · Dodgeville, WIBuilt 1968 · S/N 28-5238N7790WSpratt Don · Groveland, FLBuilt 1964 · S/N 28-1800N7791H2 Aviation LLC · Middlebury, INBuilt 1979 · S/N 17272464N7791NMinmill William J · Comfort, TXBuilt 1969 · S/N 28-5239N7791PLecompte Tom · South Berwick, MEBuilt 1962 · S/N 24-3008N7791WLunceford Andrew · Morgan Hill, CABuilt 1964 · S/N 28-1801N7792DMiner Farms LLC · Monte Vista, COBuilt 1957 · S/N 18-5994N7792NRise Aircraft 2 LLC · Tomball, TXBuilt 1968 · S/N 28-5240N7792WMoffit Matthew · West Memphis, ARFirst renewal noticeBuilt 1964 · S/N 28-1802N7793CPaolucci James H · Warwick, RIBuilt 1975 · S/N 28-7690082N7793DHolmlund Nathan R · Boring, ORS/N 18-5995N7793WEa Aircraft Holdings LLC · Myrtle Point, ORBuilt 1964 · S/N 28-1804
Back to AD 79-10-03 R2