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.

N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7127RGreen William A · Memphis, TNS/N 28-21828N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128URegistration Pending · Billings, MTRegistration pending, canceledBuilt 1992 · S/N 889N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129PBachand Cade C · Dickinson, NDBuilt 1960 · S/N 24-2292N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712DTBrown Charles A · Boise, IDS/N 575N712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712N7130DSorenson Gregory John · Hope, AKBuilt 1957 · S/N 22-4992N7130WRoye Bart L · Slaton, TXBuilt 1962 · S/N 28-928N7131BWeisel Jeffrey W · Prescott, AZBuilt 1956 · S/N 22-4350N7131LMalof Matthew P · Falls Church, VABuilt 1974 · S/N AA5-0631N7132BConsolini Joseph · Driggs, IDBuilt 1964 · S/N 22-4351N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N7132RGreydanus Samuel E · Holland, MIBuilt 1966 · S/N 28-21833N7132VCrowley Preston R · Northport, ALBuilt 1974 · S/N 20-0033N7132WN7132w LLC · Lewes, DEBuilt 1962 · S/N 28-930N7133LHutchins Perry L · Little Rock, ARS/N AA5-0433N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7133VKing Mitchell Earl · Columbus, MSBuilt 1974 · S/N 20-0034N7133WSale Reported · Tomahawk, WISale reported, pending cancellationBuilt 1962 · S/N 28-932N7134CUS Flight Academy International Inc · Post, TXS/N 28-7625070N7134DSprenger Mark R · Eagle River, AKBuilt 1957 · S/N 22-4997N7134LCook'S Aviation LLC · Conover, NCBuilt 1973 · S/N AA5-0434N7134REney Brian P · Malibu, CABuilt 1966 · S/N 28-21835N7134WHolley Donald W · Willis, TXFirst renewal noticeBuilt 1962 · S/N 28-933N7135BHillegeist Tracy L · Beverly, KSS/N 22-4354
Back to AD 79-10-03 R2