OpenAirDocs.org
AD 75-23-03

Registered aircraft · 65

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-23-03')
    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-23-03')
  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.

N1002ZArnold Sarah D · Benton, TNBuilt 1961 · S/N 984N1047ZDyer Evan H · Ann Arbor, MIBuilt 1964 · S/N 7147N10DVStringer Jeffrey H · Niskayuna, NYBuilt 1963 · S/N 6023N10LSLund Clayton L · Cheboygan, MIBuilt 1963 · S/N 6169N11EKEastern Soaring Center Inc · Petersburg, WVBuilt 1972 · S/N 13401N1200Carpenter James M · Harrisburg, NCBuilt 1966 · S/N 6521N14AAMccarter Group LLC · Helena, MTS/N 13214N154ASFlint River Soaring LLC · Bainbridge, GABuilt 1967 · S/N 13007N1618Knauff & Grove Inc · Julian, PABuilt 1967 · S/N 13033N1679Orion Flugworks LLC · Waterbury Center, VTBuilt 1968 · S/N 13073N1715Burt Compton Enterprises Inc · Marfa, TXBuilt 1967 · S/N 13026N1749Adrian Soaring Club Inc · Ypsilanti, MIBuilt 1967 · S/N 13046N1765Taylor William E · Escanaba, MIBuilt 1967 · S/N 13030N1825Powell Chuck E · Benton, KSBuilt 1967 · S/N 6619N196PLMidwestern Soaring Assoc · Peculiar, MOBuilt 1964 · S/N 6282N248SDyer Evan H · Ann Arbor, MIS/N 13003N2720COchsner David W · Clinton Twp, MIBuilt 1957 · S/N 294N3038KPfeiffer Neal J · Wichita, KSBuilt 1966 · S/N 6554N3110Stoia James W · Wagener, SCBuilt 1967 · S/N 13037N3707Kittleson Allen F · Granbury, TXS/N 13087N374TGPeterson Thomas J Jr · Newtown, PABuilt 1961 · S/N 1002N4029ALeonard Steven E · Wichita, KSBuilt 1961 · S/N 944N4099CPasquantonio Raymond · Canton, MIS/N 6058N412XLAbercrombie David R · Eatonton, GABuilt 1967 · S/N 6608N4280AWolfe Donald E · Notasulga, ALBuilt 1961 · S/N 1138N4296CManeely Roy H · Wadsworth, OHBuilt 1965 · S/N 6403N458BKClosson Luke E Jr · Valdosta, GAS/N 6043N4600TDevine Steven C · Doylestown, PAS/N 6315N4637TMetz Stephen V · Stanton, MNBuilt 1964 · S/N 7153N4700GSouthern Eagles Soring Inc · Butler, GABuilt 1964 · S/N 7164N4793TVon Tresckow Peter M · Madison, WIBuilt 1963 · S/N 6141N4938CShockey Jason M · Wharton, TXBuilt 1963 · S/N 6166N5066Markowitz Neal S · Pittsfield, MABuilt 1961 · S/N 958N545TTDyer Evan H · Ann Arbor, MIBuilt 1968 · S/N 13083N5578AFargo Air Museum · Fargo, NDBuilt 1958 · S/N 376N5597AKolberg Rocky · Kelso, WABuilt 1960 · S/N 846N5756DMiner Daniel E · Columbus, OHS/N 247N581AClosson Luke E Jr · Valdosta, GAS/N 7233N582KAPfeiffer Neal J · Wichita, KSBuilt 1958 · S/N 03N584TBurch Preston M · Sykesville, MDBuilt 1961 · S/N 934N608AClayton Harry L · Wichita, KSS/N 536N6159MAdrian Soaring Club Inc · Ypsilanti, MIBuilt 1961 · S/N 86-58N6363TWatkins Dale A · Buffalo Grove, ILBuilt 1960 · S/N 726N6384TToth Frank L · Schenevus, NYBuilt 1961 · S/N 1124N6385TCrawford Soaring Inc · Crawford, COBuilt 1962 · S/N 7014N6501DLeonard Steven E · Wichita, KSBuilt 1959 · S/N 652N6565DFlaglor Thomas R · Mosheim, TNBuilt 1960 · S/N 875N6ZSColby Robert D · Bigfork, MTS/N 6028N70703Kennin Christiane M · Killeen, TXBuilt 1962 · S/N 1133N72358Pfeiffer Neal J · Wichita, KSBuilt 1957 · S/N 337
Back to AD 75-23-03