AD 75-12-05

Registered aircraft · 87

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-12-05')
    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-12-05')
  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.

N77710Lugten Lyle · Hamilton, MIBuilt 1946 · S/N 380N77715Masterson Fred A · Calera, ALBuilt 1946 · S/N 345N77718Vyfvinkel Frederick J · New Smyrna Beach, FLS/N 348N77720Jstream Lc · Sheridan, WYBuilt 1946 · S/N 350N77721Cooper Walter O · Defiance, OHS/N 351N77724Cochran Robert M · Marathon, NYS/N 354N77725Mcdaniel Lee T · La Center, WABuilt 1946 · S/N 355N77729Price John DBA · Bennington, KSBuilt 1946 · S/N 359N77735Philbrick John F · Santa Margarita, CABuilt 1946 · S/N 365N77738Haskin Justin Wade · Odessa, TXS/N 368N77740Miller Barry W · Deltaville, VABuilt 1946 · S/N 370N77742Brown Carl E · Greenville, TXBuilt 1946 · S/N 372N77748Zumwalt B Joseph · Sheldon, ILBuilt 1946 · S/N 378N81101Mathison John M · Fernley, NVBuilt 1946 · S/N 231N81108Jstream Lc · Sheridan, WYS/N 238N81117Boomtown Aircraft LLC · Bethany, OKS/N 247N81126White Jake W · San Antonio, TXBuilt 1946 · S/N 256N81131Hamilton Dwight A · The Villages, FLBuilt 1946 · S/N 261N81132Duffin James · Bonney Lake, WABuilt 1946 · S/N 262N81134Gainsback Paul M · Mc Gaheysville, VABuilt 1946 · S/N 264N81138Dexter Fred H · Live Oak, FLBuilt 1946 · S/N 268N81139Riffle George W · Auburn, WABuilt 1948 · S/N 269N81142Vanwagnen Karen S · Jackson, MIBuilt 1946 · S/N 272N81143Jackson Thomas R Jr · Spearfish, SDS/N 273N81148Morschauser Wade M · Fond Du Lac, WIS/N 278N81153Cody Flying Club · Thermopolis, WYBuilt 1946 · S/N 283N81157Funk Aeroplane Co · Basehor, KSBuilt 1946 · S/N 287N81162Kansas Aviation Museum · Wichita, KSFirst renewal noticeBuilt 1946 · S/N 292N81173Funk Aeroplane Co · Leavenworth, KSS/N 303N81176Beach Andrew N · Hawthorne, NVS/N 306N81178O'Callaghan Sean Patrick · Oakwood, ILBuilt 1946 · S/N 308N81184Hamilton Dwight A · The Villages, FLS/N 314N81185Flight Club 502 Inc · Louisville, KYBuilt 1946 · S/N 315N81186Micetich Matthew T · Knoxville, IABuilt 1946 · S/N 316N81198Stottlemyer Brad · Lake Geneva, WIBuilt 1946 · S/N 328N82USmedley Randal C · Seadrift, TXBuilt 1946 · S/N 271N91172Heritage Flying Club LLC · Olathe, KSS/N 302
Back to AD 75-12-05