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.

N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930N1432KCovenant Physician Services Ltd · London, OHBuilt 1975 · S/N 177RG0665N1438CTony And Oats Great Adventure LLC · Danville, INBuilt 1977 · S/N 17702727N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728N1454CFreespirit Ventures LLC · Bear, DEBuilt 1977 · S/N 17702731N1455CCaruso Anthony J · Southampton, NYS/N 17702732N1479CBuilt Aviation LLC · Haymarket, VABuilt 1977 · S/N 17702735N147MLPatton Andrew Joseph · Andrews, INBuilt 1968 · S/N 17701000N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740N1521HHopkins John C Jr · Tallulah, LABuilt 1975 · S/N 177RG0698N1525HKubasch Kevin M · Longville, MNBuilt 1975 · S/N 177RG0701N1526HThompson Roy Dayton · Bulverde, TXBuilt 1975 · S/N 177RG0702N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713N153AMMedford Daniel E · Lakeville, MNS/N 17702222N1540HFurtick Reginald D · Iuka, MSBuilt 1975 · S/N 177RG0714N1541HAtkin Cris R · St George, UTBuilt 1975 · S/N 177RG0715N1542HCessna N1542h LLC · Fond Du Lac, WIBuilt 1975 · S/N 177RG0716N1544HBaugh Ashton C · Petal, MSBuilt 1975 · S/N 177RG0718N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727N1557HOpequon LLC · Vanderbilt, PABuilt 1975 · S/N 177RG0731N1559HCardair Inc · Allentown, PABuilt 1975 · S/N 177RG0733N1560HFly North Of Known LLC · Aurora, ORBuilt 1975 · S/N 177RG0734N1561HTorpey Richard T · Bay Shore, NYBuilt 1975 · S/N 177RG0735N1563HSpokane Cardinal · Spokane Valley, WABuilt 1975 · S/N 177RG0737N1565HSchornick Brad W · Oklahoma City, OKBuilt 1975 · S/N 177RG0739N1566HRohlfing Gregory C · Elmwood Park, ILBuilt 1975 · S/N 177RG0740N1567HKrimminger Michiel · Lancaster, SCBuilt 1975 · S/N 177RG0741N1568HCorner Jeremy M · Peachtree City, GABuilt 1975 · S/N 177RG0742N1569HDekalb Cardinal LLC · Evanston, ILBuilt 1975 · S/N 177RG0743N1571HYork Ronald A · West Lafayette, INBuilt 1975 · S/N 177RG0745N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752N1580HBrock Bobby Charles · New Braunfels, TXBuilt 1975 · S/N 177RG0754N1581HNevarrow Leon · Spring Valley, CAS/N 177RG0755N1582HT G & P Enterprises LLC · Glendale, AZBuilt 1978 · S/N 177RG1364N1587HFowler James C · San Angelo, TXBuilt 1975 · S/N 177RG0761N1589HAg Scouting Solutions LLC · Huntingdon, TNBuilt 1975 · S/N 177RG0763N1590HWieting Roger L · Longview, TXBuilt 1975 · S/N 177RG0764N1593HKleinert John K · Baldwin, GABuilt 1975 · S/N 177RG0767N1595HSholy Fred · Granada Hills, CAS/N 177RG0769N1597HAerobox LLC · Seattle, WABuilt 1975 · S/N 177RG0771N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038N16019Brown Kenneth D · Port Murray, NJS/N 17702478N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479
Back to AD 75-07-02