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.

N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263PHoffman Raymond F · Encinitas, CABuilt 1960 · S/N 24-2439N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564N7264WFehringer John T · Sidney, NES/N 28-1097N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265WSayles Michael A · Shorewood, ILBuilt 1963 · S/N 28-1098N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912N7266JPaolo Keath R · Carlton, ORBuilt 1968 · S/N 28-24520N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566N7266WNewland Hunter R · West Valley City, UTBuilt 1963 · S/N 28-1099N7267FRegistered aircraftBuilt 1968 · S/N 28-25187N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967N7267JSe Aviation LLC · Boise, IDBuilt 1968 · S/N 28-24464N7267WGillespie Michael Lee · Jacksonville, FLBuilt 1963 · S/N 28-1185N7268DLarsen Daniel R · Kenai, AKBuilt 1957 · S/N 18-5676N7269FChandler Joseph · Amana, IABuilt 1968 · S/N 28-25191N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569N7269WButtercup Express LLC · Woodward, OKS/N 28-1103N726ACGrass Roots Aviation LLC · Bend, ORBuilt 1999 · S/N 1276-99N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023N726GASouth Texas Air Force LLC · Mission, TXBuilt 1978 · S/N GA7-0025N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494N726JVGill James J · Anchorage, AKBuilt 1978 · S/N 18-7809088N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970N726PKSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 90-109N726RVParris Brian · Long Beach, WABuilt 1997 · S/N 23012N7270DYoung Evan G · Anchorage, AKBuilt 1957 · S/N 18-5678N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970N7270JJones Frederick W · Burgaw, NCS/N 28-24610N7270WEast West Aviation Club · DuffelS/N 28-1105N7271DCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1957 · S/N 18-5679N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678N7274JFairway Chalet LLC · San Antonio, TXS/N 28-24617N7274WSky & Sea Horizons LLC · Memphis, TNBuilt 1965 · S/N 28-2895N7275JAmon Mccrary Bryley · Bullard, TXBuilt 1968 · S/N 28-24618N7275WHinkley Dean E · Sun City, FLBuilt 1963 · S/N 28-1111N7276DDolfi Ricky Jr · Palmer, AKS/N 18-5685N7276JWheeler Kelly E · Columbia Falls, MTBuilt 1968 · S/N 28-24619
Back to AD 79-10-03 R2