OpenAirDocs.org
AD 75-20-08

Registered aircraft · 117

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-20-08')
    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-20-08')
  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.

N1013PSentinel Services Group LLC · Brooksville, FLS/N MC-428N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416N1933LN1933l Ltd · Streetsboro, OHBuilt 1976 · S/N MC-417N1937LLuks George J · Crescent City, CABuilt 1976 · S/N MC-419N1938LTexas Environmental Training & Compliance LLC · Frost, TXBuilt 1976 · S/N MC-414N1939LCook Kenneth T · Danielson, CTBuilt 1976 · S/N MC-418N1942LN1942l LLC · Wichita, KSBuilt 1976 · S/N MC-415N1953LWyatt Shawn D · Fort Worth, TXBuilt 1976 · S/N MC-421N1957LSmith Joseph M · Ames, IABuilt 1976 · S/N MC-423N1960LButler David · Palos Park, ILBuilt 1976 · S/N MC-422N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431N2044LLeitner Jay T · Hurst, TXBuilt 1976 · S/N MC-440N2046LHemby Clint L · Bonham, TXBuilt 1976 · S/N MC-433N2051LParker Joyce A · Topeka, KSBuilt 1976 · S/N MC-436N2056LHodges Fred Lloyd Jr · Ellabell, GABuilt 1976 · S/N MC-435N2165WHarrison Dan H · Englewood, FLBuilt 1974 · S/N MC252N2188WMccrea Justin M · Big Spring, TXS/N MC-258N2210LStefanov Mark · Georgetown, TXBuilt 1976 · S/N MC-441N2212LVorel Jeffrey A · Longboat Key, FLBuilt 1976 · S/N MC-442N2220LLegitimate Business LLC · Las Vegas, NVS/N MC-445N22PALubo Aviation LLC · Gastonia, NCBuilt 1974 · S/N MC-223N23PDHigh Sierra Flying LLC · Incline Village, NVBuilt 1976 · S/N MC-408N24588Fischer Paul O · Great Falls, MTS/N MC-157N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154N24PDRobertson Chad W · Hubbard, ORBuilt 1976 · S/N MC-411N24PQBlackburn Joseph E Jr · Richmond, VABuilt 1974 · S/N MC-227N2501WSolari Peter L · Lebanon, CTBuilt 1973 · S/N MC-155N2506WHeiss William R · Watkins, COS/N MC-165N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190N2508WBas Part Sales LLC · Greeley, COS/N MC-166N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172N2512WMonroe Judy L · Keller, TXBuilt 1973 · S/N MC-174N2513WDaniel Raymond C III · Newborn, GABuilt 1973 · S/N MC-171N2514WFalandys David L · Port Orange, FLBuilt 1973 · S/N MC-178N2515WRegistered aircraftS/N MC-187N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219N2545WRegistration Pending · Vienna, OHRegistration pendingBuilt 1974 · S/N MC-242N2547WBittorf Charles Shane · Clear Lake, WIBuilt 1974 · S/N MC-255N2548WGotschall Harry A · San Antonio, TXBuilt 1974 · S/N MC-257N283GWend Roger W · Charlotte, MIBuilt 1974 · S/N MC-241N39TASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N MC-230
Back to AD 75-20-08