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.

N5677UGolden Age Aviation LLC · Naperville, ILBuilt 1969 · S/N 28-26474N5677WLangel Brandon · Saint Charles, MOS/N 28-909N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035N56786Janda Robert J · Grafton, OHBuilt 1973 · S/N 28-7415012N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913N5678YTaildragger LLC · Glade Spring, VAS/N 18-8317N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013N5679DAce Flight Center Inc · Saint Thomas, VIFirst renewal noticeBuilt 1959 · S/N TD-188N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476N567DHDoyel Landy N · Klamath Falls, ORBuilt 1998 · S/N 5152N567GAAdkins Gordon L · Kenova, WVBuilt 2004 · S/N 3668N567RVMarini Robert A · Brighton, COBuilt 1991 · S/N 20567-RV6N567VEEngbring Jered · Durango, COBuilt 2026 · S/N JE001N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938N56831Burns Robert A · Fort Myers, FLFirst renewal noticeBuilt 1973 · S/N 28-7415015N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940N56847Nepsund Michael L · Park Rapids, MNBuilt 1973 · S/N 28-7415017N56849Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 28-7415018N5684WSeverino Racli · Closter, NJBuilt 1963 · S/N 28-948N5685PWalker Richard E · Quanah, TXBuilt 1959 · S/N 24-757N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125N5685UTres Amigos Flying Club LLC · Redding, CABuilt 1969 · S/N 28-26482N5685WRempel Steven P · Prague, OKBuilt 1962 · S/N 28-953N56860Horst Michael D · Chambersburg, PABuilt 1973 · S/N 28-7415019N56861Wingsleasing LLC · Wichita, KSBuilt 1973 · S/N 28-7405035N5686UHobbs Stanley T · Middleburg, FLBuilt 1969 · S/N 28-26483N5686WPromedical Inc · Pfafftown, NCBuilt 1962 · S/N 28-954N5687QRegistered aircraftBuilt 1965 · S/N 3042N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127N56887Leavitt Teyvin M · Coeur D Alene, IDS/N 28-7425059N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128N5688WSerendipity Rentals LLC · Denver, COBuilt 1963 · S/N 28-1013N56898Evans Katrina · Watkinsville, GABuilt 1973 · S/N 28-7425061N56899Mcdonald George · Inverness, FLBuilt 1973 · S/N 28-7415022N5689PMarsala Joseph · Uxbridge, MABuilt 1959 · S/N 24-761N5689QReynolds Shawn E · Ventura, CAS/N 3043
Back to AD 79-10-03 R2