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.

N6132JWolf Aviation Network Inc · Westfield, MABuilt 1976 · S/N 28-7615309N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584N61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065CN6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611N6133HCbc Aviation LLC · Hayden, IDBuilt 1979 · S/N 1085-79N6133JArbello Danny · Sterling, VAS/N 28-7615310N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571N6134SPatten Jeffery D · Rapid City, SDBuilt 1965 · S/N 18-41N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151N6135DHowe Bryan · Edgewater, FLBuilt 1956 · S/N 22-4779N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152N6137DPhelps Joe · Princeton, KYBuilt 1957 · S/N 22-4781N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994N6137WPrepmasters Inc · Boynton Beach, FLS/N 28-20134N6138VGlover Michael M · Mechanicsville, VABuilt 1968 · S/N 28-23988N6139WFleetwood James D · French Lick, INBuilt 1964 · S/N 28-20157N613APThomas Lucas G · Beebe, ARBuilt 1976 · S/N 190-76N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492N613PCPrivitt Bret J · Forest Hill, TXBuilt 1999 · S/N 1255-98N613RVFlege Jordan T · Morrow, OHBuilt 2000 · S/N 80266N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240N6140JWeldy Mark L · Etna Green, INBuilt 1976 · S/N 28-7615311N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N61411Vincent Tarissa · Westminster, COS/N 1151N6141JRnt Air LLC · Mitchell, SDBuilt 1976 · S/N 28-7615312N6141VWright Lawrence D · West Chester, PABuilt 1965 · S/N TD-614N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N6142DManbeck Michael R · Summerville, SCBuilt 1957 · S/N 22-4786N6142PAllison Trent Van · Southlake, TXBuilt 1959 · S/N 24-1243N6142SKelly Robert D · Sheboygan, WIFirst renewal noticeBuilt 1965 · S/N 18-50N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6144DCarter Tim R · Morgan, UTBuilt 1957 · S/N 22-4788N6144NDunn Rick · Benton, ARS/N MB-415N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162N6145DLindsey Christopher T · Nesbit, MSBuilt 1957 · S/N 22-4789N6145WRegistered aircraftS/N 28-20163N61465Bishop Michael D · Pulaski, TNS/N 12-3189N6146PMount Up Aviation LLC · Kirbyville, MOS/N 24-1247N6147DRegistered aircraftBuilt 1957 · S/N 22-4792N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229N6147RBloom James F · Clay City, KYS/N 172RG0094N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230N6148JNorth Texas Flight Ventures LLC · Mckinney, TXBuilt 1976 · S/N 28-7615313N6148NAll-In-Aviation LLC · Paragould, ARBuilt 1969 · S/N M-1225
Back to AD 79-10-03 R2