OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164N3315EBas Part Sales LLC · Greeley, COS/N 17271501N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373N331DHEaves Donald Ray · Byhalia, MSFirst renewal noticeBuilt 2000 · S/N 21754N331DWHaehnel Patrick J · Elbert, COBuilt 2001 · S/N 001N331FBurton Charles E · Jackson, CABuilt 2001 · S/N 5703N331GPDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 44-7995277N331GTPope Kent M · Hayden, IDBuilt 1984 · S/N 331N331JBBostik Josef J · Green Cove Springs, FLBuilt 2002 · S/N 25108N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477N331NTCrowley E Ned · Londonderry, NHS/N N.C.1N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514N331RDHiggins Roland · Solon Springs, WIBuilt 2005 · S/N 25720N331VRRoof Jerry G · Centennial, COBuilt 1991 · S/N 509N331WTillman Nickolas R · Piggott, ARBuilt 1972 · S/N 287225543N331WBAb Aviation LLC · Ashland, OHBuilt 1969 · S/N 28-5401N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255N3321LN3321l LLC · Dacula, GAS/N 3321N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621N3322KHamilton Roger A Trustee · Pisgah Forest, NCBuilt 1975 · S/N AA5B-0046N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296N3323TDeese James K Jr · Charlotte, NCS/N 17700623N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277N3326TGallman Doug M · Port Orange, FLBuilt 1967 · S/N 17700626N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224N3327TFriedl Robert Stephen Jr · Mammoth Lakes, CAS/N 17700627N3327ZMessinger Donald C · Wasilla, AKBuilt 1960 · S/N 22-7264N3328ENorthwoods Air LLC · Orono, MES/N 17271505N3328QEastman John T · Winfield, KSBuilt 1977 · S/N 28-7725223N3329MMcleod Michael R · Inlet Beach, FLBuilt 1994 · S/N 2879N3329PStradley Anna M Trustee · Bozeman, MTBuilt 1958 · S/N 23-1280N332JBMcalee Jeremy D · St Johns, FLBuilt 1976 · S/N AA5B0359
Back to AD 79-10-03 R2