OpenAirDocs.org
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.

N1601NStrahan Ronald R · Girard, KSBuilt 1946 · S/N 383N1605NGraham Douglas R · Palmer, AKS/N 390N1607NHuntley Lawrence H · Hernando, FLBuilt 1946 · S/N 392N1608NKankakee Valley Aviation LLC · Wanatah, INBuilt 1946 · S/N 393N1609NFunk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 394N1611NHistoric Aircraft Restoration Museum · Saint Louis, MOBuilt 1947 · S/N 411N1612NHoffman Conrad · Madison, SDBuilt 1947 · S/N 410N1613NSage Terry L · Tyler, TXBuilt 1947 · S/N 431N1616NSaari Michael J · Sycamore, ILBuilt 1947 · S/N 402N1617NTippit Larry J · Grand Prairie, TXS/N 403N1618NDeshl-Air Flying Club · Custar, OHBuilt 1947 · S/N 404N1626NHoward Kenneth L · Collinsville, OKS/N 406N1632NVelemirov Michael L · Akron, OHBuilt 1947 · S/N 412N1634NGooden John A · Tulsa, OKS/N 414N1639NFrisby Craig · Rexburg, IDBuilt 1947 · S/N 419N1642NJstream Lc · Sheridan, WYBuilt 1947 · S/N 422N1644NNafziger Brian L Trustee · Cincinnati, OHBuilt 1947 · S/N 424N1646NBlackmon Tommy J · Abilene, TXS/N 426N1647NBeach Andrew N · Hawthorne, NVBuilt 1947 · S/N 427N1650NSale Reported · La Plata, NMSale reportedBuilt 1947 · S/N 430N1654NMaxfield John O · Canton, MIBuilt 1948 · S/N 438N1655NScheufler Mark E · Seven Bays, WAS/N 439N22678Coffeyville Aviation Heritage Inc · Coffeyville, KSBuilt 1939 · S/N 5N22681Morozowsky Anthony M · Zanesville, OHBuilt 1948 · S/N 7N22683Morozowsky John S · Zanesville, OHBuilt 1939 · S/N 10N22691Morozowsky Anthony M · Zanesville, OHBuilt 1939 · S/N 18N24106Maley Christopher L · Otsego, MIBuilt 1940 · S/N 32N24115Lockhart Michael G · Coral Springs, FLBuilt 1940 · S/N 47N24118Morozowsky Anthony M · Zanesville, OHBuilt 1940 · S/N 44N24134Airpower Museum Inc · Ottumwa, IABuilt 1940 · S/N 60N24148Morozowsky Anthony M · Zanesville, OHBuilt 1940 · S/N 74N24152Miller Michael S · Wills Point, TXS/N 178N24154Beranek James D · Cottage Grove, ORBuilt 1940 · S/N 180N24157Indy Air Sales LLC · Anderson, INBuilt 1940 · S/N 183N2415ELaux Christopher B · Gladstone, MOBuilt 1939 · S/N 8N24160Gubert Kurt F · Ashley, MIS/N 186N24162Morozowsky Anthony M · Zanesville, OHBuilt 1940 · S/N 188N24166Jstream Lc · Sheridan, WYS/N 191N24167Laible Lawrence Sr · Topeka, KSS/N 193N24168Funk Aeroplane Co · Basehor, KSBuilt 1940 · S/N 194N24170Hanna Bay Holdings LLC · Hayward, WIBuilt 1940 · S/N 196N24173Cooper Walter O · Defiance, OHBuilt 1940 · S/N 199N24181Funk Aeroplane Company · Basehor, KSBuilt 1940 · S/N 207N284EWWeiler Durand E · Caldwell, IDBuilt 1941 · S/N 210N32459Kanasas Aviation Museum · Wichita, KSS/N 1N332TSBeach Andrew W · Hawthorne, NVS/N 293N41741Funk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 223N41747Dates Edmund H · Red Creek, NYS/N 229N49940Jennings Dana B · Gates, ORBuilt 1940 · S/N 29N77705Anderson Dennis R · Brush Prairie, WABuilt 1946 · S/N 336
Back to AD 75-12-05