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.

N5737WUltimate Airparts LLC · Strasburg, VABuilt 1963 · S/N 28-1426N57385Victor Foxtrot LLC · Scott City, KSBuilt 1973 · S/N 260-73N5738QGuillen Gregorio J · Lopatcong, NJS/N 3071N5738UFlorida Time Building LLC · Port Saint Lucie, FLS/N 28-26554N5738WCherokee 38whiskey LLC · Charlotte, NCBuilt 1963 · S/N 28-1434N57395Zangs William J · Poplar Grove, ILBuilt 1973 · S/N 488-73N5739DSmith James A · Lyle, WABuilt 1956 · S/N 22-4439N5739QMorell Timothy S · Lino Lakes, MNBuilt 1965 · S/N 3108N5739WFeralova Erika H · Gresham, ORBuilt 1963 · S/N 28-1425N573ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496198N573ELStellaire Alliance LLC · Fort Worth, TXBuilt 1999 · S/N 2038N573MWWhelan Company LLC · Hoover, ALBuilt 2005 · S/N 90815N573SMason Scott C · Lebanon, ORBuilt 1976 · S/N 913N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072N5740UBraden Daniel · Port Charlotte, FLBuilt 1969 · S/N 28-26556N5740WAdams Clay · Anacortes, WABuilt 1963 · S/N 28-1415N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57422Heefner Frederick C · Greencastle, PABuilt 1998 · S/N 23077N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444N5744ULance Sylvia · Acushnet, MABuilt 1970 · S/N 28-26564N5744WGarrett Jackson Trustee · Pleasant Garden, NCBuilt 1963 · S/N 28-1447N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159N5745UMccormick Todd L · Ankeny, IAS/N 28-26565N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N5746QKing Jeremy · Sandy Springs, GAS/N 3075N5746USale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28-26567N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447N5747FMsol Air LLC · Lakeland, FLBuilt 1968 · S/N 28-25048N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N5749WDch Aviation LLC · Owasso, OKBuilt 1963 · S/N 28-1467N574ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496199
Back to AD 79-10-03 R2