AD 75-07-02

Registered aircraft · 2,162

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:75-07-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-07-02')
  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.

N13468Wanner Kevin M · Morristown, NJBuilt 1976 · S/N 17702424N13484Aero-Flite Corp · Murfreesboro, TNBuilt 1976 · S/N 17702426N13493Pelaez Gilberto · Chatsworth, CABuilt 1976 · S/N 17702427N13511Meteor Aviation · Kirkland, WAFirst renewal noticeS/N 17702430N13515412 Jw Aviation LLC · Dover, DEBuilt 1976 · S/N 17702431N1351CSapphire Vistas LLC · Iowa City, IAFirst renewal noticeBuilt 1977 · S/N 17702708N13526Rolla Aero Inc · Rolla, NDBuilt 1976 · S/N 17702433N1353CMason Teresa J · Tucson, AZBuilt 1977 · S/N 17702709N13541Lowcountry Flying Club · Moncks Corner, SCBuilt 1976 · S/N 17702434N13564Cain James W · Big Rapids, MIBuilt 1976 · S/N 17702437N13565Williams Jim J · Jackson, NJBuilt 1976 · S/N 17702438N1357CSummit Concepts Inc · Wilmington, DES/N 17702710N13596Gary Rollin F · Dallas, TXS/N 17702440N13597Heeter Michael · Bloomington, MNBuilt 1976 · S/N 17702441N1359CCromer Aubrey E · Anderson, SCBuilt 1977 · S/N 17702711N13612Harry Philip Scott · Asheville, NCBuilt 1976 · S/N 17702443N1361CHuckaby William C Trustee · Loudon, TNBuilt 1977 · S/N 17702712N13621Fowler Gerald · Springfield, MOBuilt 1976 · S/N 17702444N13647Winn William D · Fallbrook, CABuilt 1976 · S/N 17702447N13656Groth Abigail · Oxford, GAS/N 17702448N13667Fuller Air Inc · Wilmington, DEBuilt 1976 · S/N 17702450N13669Hypersonic Handler Inc · Essex, IABuilt 1976 · S/N 17702451N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454N13710Registered aircraftBuilt 1976 · S/N 17702456N1371MPlamondon Jon Trustee · Reno, NVBuilt 1971 · S/N 177RG0081N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463N1373CDoft Peter · San Diego, CAS/N 17702714N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715N1377CCavok LLC · Wilmington, DES/N 17702716N13804Henderson Jeannie · Colorado Springs, COS/N 17702470N13819Avco Patrol LLC · Lyndon, KSBuilt 1976 · S/N 17702471N1381CEagle Sky Patrol Inc · Deadwood, SDBuilt 1977 · S/N 17702718N1384CRedwood Area Flyers LLC · Redwood Falls, MNBuilt 1977 · S/N 17702719N13892Meyers Alexander C · Pittsburgh, PABuilt 1976 · S/N 17702475N138JPChang Denny · Easton, PABuilt 1970 · S/N 17701442N138RCBardin G W · Granville, NYBuilt 1976 · S/N 177RG0994N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720N13HKSkycombers Flying Club Inc · Pacoima, CABuilt 1972 · S/N 17701810N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724
Back to AD 75-07-02