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.

N45187Hill Samuel D · Dover, DEBuilt 1978 · S/N AA5B0803N4518AJensen Dustin C · Santa Clara, UTS/N 22-3824N4518BSmoke Seen LLC · Farmingdale, NYBuilt 1978 · S/N AA5B1038N4518ERegistered aircraftBuilt 1978 · S/N AA5B1039N4518KBrush Creek Farmhouse LLC · Valparaiso, INBuilt 1978 · S/N AA5B1040N4518QLloyd Patrick · Durham, NCBuilt 1978 · S/N AA5B1044N4518REdmondson William A · Rosamond, CAFirst renewal noticeBuilt 1965 · S/N 28-21220N45199Decou Miller C · Chester Springs, PABuilt 1979 · S/N AA5B1059N4519EPalocz Spencer F · Weston, MABuilt 1979 · S/N AA5B1051N451BTNeosho Investments LLC · Neosho, MOBuilt 1967 · S/N 28-23951N451CDDull Kevin M · Northlake, TXBuilt 1978 · S/N AA5B0995N451DDJth Holdings LLC · Flemingsburg, KYBuilt 1990 · S/N 1451N451PSUpside Down Aero LLC · Aberdeen, IDBuilt 1976 · S/N 193-76N452Chace Stephen B · Bloomington, ILBuilt 1986 · S/N 632N45204Markelov Sergey · Naperville, ILBuilt 1979 · S/N AA5B1067N45208Bunker Wayne M · Cape Carteret, NCBuilt 1979 · S/N AA5B1069N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063N4520RBurge John A · Pensacola, FLS/N 28-21222N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089N4522ABryant Stephen · Anchorage, AKS/N 22-3829N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091N4523RGardner Michael J · Ashland, ILS/N 28-21225N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112N45249Porus Joseph B · Oakland, NJBuilt 1979 · S/N AA5B1115N4524BBarbero Matias J · Cape Coral, FLBuilt 1979 · S/N AA5B1098N4524EHarper Michael B · Buena Vista, COBuilt 1979 · S/N AA5B1099N4524KMorris David R · Montara, CABuilt 1979 · S/N AA5B1100N4524NHorejsi Michael E · Castro Valley, CABuilt 1979 · S/N AA5B1103N4524PRegistered aircraftBuilt 1979 · S/N AA5B1105N4524QRegistered aircraftBuilt 1979 · S/N AA5B1106N4524WRichardson Shane D · Pekin, ILBuilt 1979 · S/N AA5B1109
Back to AD 79-10-03 R2