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.

N6453WN6453w LLC · Orlando, FLS/N 28-20526N64541Corbett William C · Havelock, NCBuilt 1975 · S/N 17265295N64542American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265296N64543Rcr Aviation LLC · Mansfield, OHBuilt 1975 · S/N 17265297N64545Airplane And Drone Flight Instruction LLC · Windermere, FLBuilt 1982 · S/N 17275575N64549Gipson Scott Lane · Beach City, TXBuilt 1978 · S/N 1N6454GRoberge James F · Waterville, MES/N 17273598N6454WSm Aviation LLC · Clermont, FLBuilt 1964 · S/N 28-20527N6454ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-638N64555Corbin Lawrence W · Fort Wayne, INBuilt 1978 · S/N 165N64556D & S Aviation LLC · Spring, TXBuilt 1982 · S/N 17275578N6455JCartier Edward J Jr · Columbia, MSBuilt 1968 · S/N 28-4876N6455SDaniel L Cooper · Palmer, AKBuilt 2003 · S/N AF18022N6455VCrown Flying Club Inc · Olathe, KSBuilt 1981 · S/N 172RG0711N6456JCherokee Dream Inc · Wilmington, DEBuilt 1968 · S/N 28-4877N6456RCash Douglas Edward · San Antonio, TXBuilt 1966 · S/N 28-21642N64575N64575 LLC · Cheyenne, WYBuilt 1982 · S/N 17275585N6457DTristar Aviation Services LLC · Hendersonville, TNBuilt 1979 · S/N 17272809N6457JHatcher Clifford J · Dallas, GABuilt 1968 · S/N 28-4878N6457WWeston Keith M · Ogdensburg, NYBuilt 1964 · S/N 28-20530N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645N6459ULinck Market Inc · Little Rock, ARBuilt 1962 · S/N 2205N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305N645DTScenic Mountain Air Inc · Moose Pass, AKBuilt 1982 · S/N 18-8309022N645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553N645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTBuilt 2009 · S/N 90541N645RFHagge Hal E · Eagle River, AKBuilt 1968 · S/N 18-8711N645SAGerrish Ronald M · San Antonio, TXBuilt 2005 · S/N S-0007N64608A S Air LLC · Lantana, FLS/N 17275592N6460DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 19640N6460UHayes Toby G · Idaho Falls, IDBuilt 1962 · S/N 2206N64617Melbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275594N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425N6461RBetsy N6461r LLC · Novato, CABuilt 1966 · S/N 28-21648N6461VRegistered aircraftBuilt 1980 · S/N 172RG0716N6461WOverstreet Aviation LLC · Sunray, TXBuilt 1964 · S/N 28-20534N6462CA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816426N6462DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272813N6462JRentz Bradford C · Baxley, GABuilt 1968 · S/N 28-4885N6462RGoodens Floorcovering Inc · Tallapoosa, GABuilt 1966 · S/N 28-21650N6462UAnderton Roy · Colbert, OKBuilt 1962 · S/N 2209N6462VVanbergen Shaun S · Ashland City, TNBuilt 1980 · S/N 172RG0717N6462WBauer Richard M · Greensboro, NCBuilt 1965 · S/N 28-21264N6463GTeens-In-Flight Inc · Palm Coast, FLBuilt 1979 · S/N 17273599N6463JSorenson Mark A · Senoia, GABuilt 1968 · S/N 28-4886N6464DHoney B LLC · Hillsboro, ORS/N 17272815
Back to AD 79-10-03 R2