OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,027

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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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.

N20358Ricky B'S Bodyshop Inc · Berthoud, COBuilt 1977 · S/N 17702661N2035QDonn E Mount Realty Inc · Titusville, FLBuilt 1973 · S/N 177RG0435N2036QEtling Carl G · Edgar, NEBuilt 1973 · S/N 177RG0436N2036RElsing Myles H · La Quinta, CABuilt 1964 · S/N 18255236N20375May Matthew J · Weatherford, TXBuilt 1977 · S/N 17702664N2037RVertical Ascent LLC · Breckenridge, COBuilt 1964 · S/N 18255237N2037XDavis Russell C · Greenbrae, CABuilt 1965 · S/N 18256137N2038RScaturro Timothy P · Lakewood, COBuilt 1964 · S/N 18255238N20394Eller Ralph E · Wasilla, AKS/N 17702668N2039RChurch Of The Word International Inc · East Earl, PABuilt 1964 · S/N 18255239N20403Deatherage Edward D · Salina, KSBuilt 1977 · S/N 17702669N2040REco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N 18255240N2040XBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 18256140N20410Widjokongko Antonius · League City, TXBuilt 1977 · S/N 17702670N2041QGarcia Cameron A · Yukon, OKBuilt 1973 · S/N 177RG0441N2042RJanssen David W · Ault, COBuilt 1964 · S/N 18255242N2043QAnderson Michael R · Bedford, INBuilt 1973 · S/N 177RG0443N2044QWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1973 · S/N 177RG0444N2044RMiller Steven Chris · Royse City, TXBuilt 1964 · S/N 18255244N2044XNc Flyers LLC · Raleigh, NCBuilt 1965 · S/N 18256144N2045XOsborne David A · Helotes, TXS/N 18256145N2047QMeersma Montgomery D · Atlanta, GABuilt 1973 · S/N 177RG0447N2049QDdv Equipment Leasing LLC · Cheyenne, WYBuilt 1973 · S/N 177RG0449N2049XTaylor Stephen A · Benton, KSBuilt 1965 · S/N 18256149N2050RMills James A · Fayetteville, GABuilt 1964 · S/N 18255250N2050XWhite Levi E · Joliet, MTBuilt 1965 · S/N 18256150N2051QErwa Mohamed · Cedar Park, TXBuilt 1973 · S/N 177RG0451N2051R2051 Aviation LLC · Spokane, WAS/N 18255251N2052QCentral Virginia Aviation Inc · Petersburg, VABuilt 1973 · S/N 177RG0452N2053XGolden Richard J · Stafford, VABuilt 1965 · S/N 18256153N2054QLawrence Bradley R · Payson, AZBuilt 1974 · S/N 177RG0454N2054RRiptide Investments LLC · Baker, FLBuilt 1964 · S/N 18255254N2054XVoz Garth O · Gonzales, TXBuilt 1965 · S/N 18256154N2055XMartin Robert L Jr · Havana, ILBuilt 1965 · S/N 18256155N2056QElecsys LLC · San Marcos, CABuilt 1973 · S/N 177RG0456N2056XWhite Christy · Wichita, KSBuilt 1965 · S/N 18256156N2057XLewis Tommy · Winnsboro, TXBuilt 1965 · S/N 18256157N2058QN2058q LLC · Washington, PABuilt 1973 · S/N 177RG0458N205AAHzl Hanger LLC · Drums, PAS/N 205-0453N205AWLee Kevin B · Beulah, NDBuilt 1963 · S/N 205-0522N205BBHixon George S · San Antonio, TXBuilt 1962 · S/N 205-0060N205BPRegistered aircraftBuilt 1962 · S/N 205-0089N205CLFreedenberg Philip J · Canton, CTBuilt 1963 · S/N 205-0452N205CRRlh Montana LLC · Helena, MTBuilt 1963 · S/N 205-0286N205CTBas Part Sales LLC · Greeley, COS/N 205-0226N205FBennett James G · Erie, COBuilt 1964 · S/N 205-0573N205FJPilots Nw Inc · Bellingham, WABuilt 1962 · S/N 205-0050N205HNTischer Jesse · Des Moines, IABuilt 1963 · S/N 205-0440N205JNHand Patrick · Cape Charles, VABuilt 1967 · S/N 18258437N205LSky King Airplanes LLC · Lewes, DEBuilt 1963 · S/N 205-0329
Back to AD 72-03-03 R3