OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,395

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.

N2337LAbitia Alberto · Phoenix, AZBuilt 1963 · S/N M-168N2337QFleener Michael C · Livingston, TXS/N M-402N2338QWinkels Jeffrey P · Candy, MNFirst renewal noticeBuilt 1963 · S/N M-403N2338YCm3 LLC · North Las Vegas, NVS/N 2152N2339PMulvania Rodney A · Linn, MOBuilt 1955 · S/N 22-2750N2339YGross Barbara J · Timber Lake, SDS/N 17700139N233HYTen Mile Ranch Inc · Vale, ORBuilt 2003 · S/N 2233N233SPBuchwald Greg W · Grapevine, TXBuilt 1961 · S/N 28-223N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920N2340LRegistration Pending · San Antonio, TXRegistration pendingBuilt 1962 · S/N M-171N2340QRegistration Pending · Lewisville, TXRegistration pendingBuilt 1963 · S/N M-411N2340SWhalen Patrick M · Anchorage, AKBuilt 1979 · S/N 18-7909134N23412Performance Sanitation Of Mississippi LLC · Deland, FLBuilt 1995 · S/N 23412N2341TSky King Aviation LLC · Kearney, MOBuilt 1971 · S/N 28-7225048N2342AThomas Todd · Sandy Hook, MSBuilt 1952 · S/N 22-732N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245N2342LWilliams James W · Brush Prairie, WABuilt 1963 · S/N M-173N2342UAdvanced Helicopter Concepts Inc · Frederick, MDFirst renewal noticeBuilt 1992 · S/N 2181N2343HAerobinninger LLC · Mccall, IDBuilt 1979 · S/N 18-7909173N2343LBailey Paul W II · Hilton Head, SCBuilt 1963 · S/N M-174N2343PStalder Fredrick Bleu · Magnolia, TXBuilt 1955 · S/N 22-2754N2343RSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1969 · S/N 28-5495N2343TManire Christine D · Ruidoso, NMBuilt 1971 · S/N 28-7225049N2344LSpargo Lyle R · Tonopah, AZBuilt 1963 · S/N M-175N2344PVieaux James M · Park Forest, ILBuilt 1955 · S/N 22-2755N2345LD&S Development LLC · Spring, TXS/N M-177N2345PSpitzer Helicopter LLC · Woodland Hills, CABuilt 1991 · S/N 1991N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145N2345ZRegistered aircraftBuilt 1977 · S/N 17270190N2346QBurt Marcus D · Pendleton, ORS/N M-425N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65N2347QBefumo Joesph M · Manchester, CTS/N M-451N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60N23490Lg Mcdonald Enterprises Inc · Rose Bud, ARBuilt 1992 · S/N 2223N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61N234ARHague Arsh · Orangeburg, NYBuilt 1977 · S/N AA5B0452N234BMHickey John W · Monterey, CABuilt 1985 · S/N 1330N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369N234ECCook James C · Waverly, ALBuilt 1984 · S/N 234N234GBChristensen Gary B · Mesa, AZBuilt 2017 · S/N 60161N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438N234HUStevens Matthew S · Penn Yan, NYBuilt 1996 · S/N 1336N234JCL&L Air LLC · Cave Creek, AZBuilt 1976 · S/N 28-7715093N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225N234KMMurray Edward L · Hoover, ALS/N 28-7990043
Back to AD 79-10-03 R2