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.

N6148WAir Ventures Flying School LLC · Smithfield, RIBuilt 1964 · S/N 28-20167N61494Millican Marc J · Anchorage, AKS/N 18-5712N614973 Dudes 1 Plane LLC · Olympia, WABuilt 1976 · S/N 28-7625109N6149JAeroventures Flying Club Inc · Lilburn, GABuilt 1976 · S/N 28-7615314N6149NZappa Tyler M · Hudson, FLBuilt 1969 · S/N M-1226N6149TCrawford Iain A · Perkinsville, VTBuilt 1992 · S/N 20303-1JWN6149VFoode Frank J · Cordova, AKBuilt 1980 · S/N 172RG0587N614ACLawless Aviation LLC · Fishers, INBuilt 2001 · S/N 454-2001N614AZWienholt Robert Jr · Perry Hall, MDBuilt 1985 · S/N 17276475N614CGC3 Aircraft LLC · Burnet, TXBuilt 2001 · S/N 9926CCN614DPInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 447995119N614EDClark Richard A · Warren, MIBuilt 2002 · S/N 23102N614FLEagle Sky Patrol Inc · Deadwood, SDBuilt 1971 · S/N 28-7125493N614JMLynch Bradley J · Fenton, MOBuilt 2001 · S/N 24903N614PSAeronaut Technolgy LLC · Jacksonville, FLS/N 28-7415134N614RGLittle Shiz Llcr LLC · Kalispell, MTBuilt 2003 · S/N 1979N614VZVision Aircraft LLC · Scottsdale, AZBuilt 1981 · S/N 17275258N614WTJamestown Jet Center Inc · Jamestown, NDBuilt 1968 · S/N 28-23777N6150DPayne David J · Eagle River, AKS/N 22-4797N6150FFranklin Aviation LLC · Paradise, CABuilt 1979 · S/N 17273156N6150JCypress Aviation LLC · Malvern, PAS/N 28-7690353N6150RChristy David L DBA · Meriden, KSBuilt 1979 · S/N 172RG0095N6151HFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7890211N6151ZRotor And Wing LLC · Tioga, NDBuilt 1960 · S/N 25-177N61526Mata Joseph F · E Setauket, NYBuilt 1982 · S/N M-2348N6152DFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 22-4799N6152VClayton Stephen C · Conyers, GABuilt 1970 · S/N 17258999N6152WRogers Samuel I · Leroy, KSBuilt 1964 · S/N 28-20171N61531Aero Maintenance Inc · Vancouver, WAS/N 17264619N61534Registration Pending · Cheney, KSRegistration pendingBuilt 1974 · S/N 17264621N61536Aerolanding LLC · Enterprise, ALBuilt 1974 · S/N 17264622N61539N61539 LLC · Arvada, COBuilt 1974 · S/N 17264624N61544Knudsen Russell G · East Troy, WIBuilt 1974 · S/N 17264628N61547Frontline World Missions Inc · Jacksonville, TXBuilt 1974 · S/N 17264630N61548Adamson Daniel A · Moscow, OHBuilt 1974 · S/N 17264631N6154DRoss Winn J III · Rochester, ILS/N 22-4801N6154HTravis Air Force Base Aero Club · Travis Afb, CABuilt 1977 · S/N 28-7890212N61557Angle Of Attack LLC · Boise, IDBuilt 1975 · S/N 17264638N6155DCurtis Jeremy A · Fairbanks, AKBuilt 1957 · S/N 22-4802N6155JAnderdoc Aviation Inc · Wilmington, DEBuilt 1974 · S/N AA50503N6155KFreeway Airport Inc · Mitchellville, MDBuilt 1980 · S/N 17274170N61566Modin John · El Dorado Hills, CABuilt 1974 · S/N 17264644N61567Enzyme Holdings LLC · Wilmington, DEBuilt 1975 · S/N 17264645N6156WHousley Steven W · Hot Springs, SDS/N 28-20175N61571Engineers Flying Club Inc · Bethany, OKBuilt 1975 · S/N 17264648N61573Registered aircraftS/N 17264650N61574Bruns Michael Wesley · Scottsdale, AZBuilt 1974 · S/N 17264651N61577Ingle Daniel B · Coraopolis, PABuilt 1975 · S/N 17264653N6157DBadinelli Ralph D · Blacksburg, VABuilt 1957 · S/N 22-4804N6157FLa Placa Peter · Lake Havasu City, AZBuilt 1973 · S/N A1500434
Back to AD 79-10-03 R2