OpenAirDocs.org
AD 47-30-08

Registered aircraft · 164

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:47-30-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:47-30-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.

N1165SStark David M · Merkel, TXS/N CA-16251N21039Herzog Eric M · New Waverly, TXBuilt 1938 · S/N KM-4N21371Hilbert Elroy E II · Rockford, ILS/N C1808N22103Allred Gina D Administrator · Centre, ALS/N LA-2108N22375Balsavage Roy Frederick · Douglas, GAS/N L-3769N22478Avery Michael L · Cumberland, WIBuilt 1939 · S/N C4249N23516Krueger Kevin K · Niagara, NDBuilt 1939 · S/N L-4669N23962Stagg Skip W · Lakewood, CABuilt 1939 · S/N 6229N23970Breier Rolf · Callaway, FLS/N L-6299N24206Fike William E · Atlanta, GAS/N L-6709N24209Wright William F · Cleveland, OKBuilt 1939 · S/N L-6739N24228Robinson Raymond E · Nevada, IABuilt 1939 · S/N L-6949N24231Wieman Dianne L · Marion, TXBuilt 1939 · S/N L-6979N24244Thomas George P Jr · Woodstock, VTBuilt 1939 · S/N L7119N24248Wells Sherry A Trustee · Ferndale, MIS/N L-7189N24276Air Chief Inc · Somerset, PABuilt 1941 · S/N L-7510N24284Gifford Vernon D · Starkville, MSBuilt 1940 · S/N L-7540N24286Zech Tyler K · Orlando, FLS/N L-7480N26315Graham Craig W · Anacortes, WABuilt 1940 · S/N LA-7810N26318Finseth Lowell J · Fountain, MNBuilt 1940 · S/N 7880N26321Southern Arkansas University Tech · East Camden, ARBuilt 1940 · S/N L-7850N26328Gilbert James D · Kansas City, KSBuilt 1940 · S/N L7940N26329Bennett Ronald J · Houston, TXBuilt 1940 · S/N L-7950N26377Petersen Tim G · Cambridge, NES/N L8410N27302Ching Radford G · Elsie, MIS/N L8500N29206Bendix Airmens Association Inc · Wilmington, DEBuilt 1940 · S/N C10060N29229Massey Wayne L · Okahumpka, FLBuilt 1940 · S/N C-10150N29248Free Alan R · Paulding, OHBuilt 1940 · S/N CA10210N29427Lamphar Eric Matthew · Lebanon, OHBuilt 1940 · S/N CA10220N29433Zenor Dean C · Lake City, IABuilt 1940 · S/N CA-10310N29445Brunhoeber Michael E · Caldwell, KSBuilt 1940 · S/N C-10300N29497Johnson Donald W · Sharpsburg, GABuilt 1940 · S/N C10440N31329Neno Richard J Sr · Ithaca, NYBuilt 1940 · S/N C10490N31350Varrasse Raymond R · Yulee, FLBuilt 1940 · S/N C-10370N31393Roberson Henry B · Chico, CABuilt 1940 · S/N C10550N31413Kelly Bryan P · Clearwater, MNBuilt 1940 · S/N CA10640N31422Klingenberg Tim C · Udall, KSBuilt 1940 · S/N CA10750N31738Rusty Robertson · Fresno, CABuilt 1940 · S/N CA10910N31771Martin Aviation LLC · Bargersville, INBuilt 1940 · S/N C-11080N31797Graham Bruce M · Amarillo, TXBuilt 1940 · S/N CA-11140N31807Gores Thomas J · Franklin, WIS/N C11220N31854Moulder Clayton J · Jensen Beach, FLS/N CA11440N31886Wolcott James N · Grandview, TXBuilt 1944 · S/N C-11711N31892Dorman Richard E · Mesa, WABuilt 1941 · S/N C-11721N31895Gores Thomas J · Franklin, WIBuilt 1941 · S/N C11671N31899Byrne Donald L Jr · Lusby, MDBuilt 1941 · S/N CA-11981N31903Mullins Adrian J · Cartersville, GABuilt 1941 · S/N CA-11841N31925Woodhams Jonathon R · South Haven, MIBuilt 1941 · S/N CA12031N31928Hammons John M · Grapeland, TXS/N CA12101N31954Gores Thomas J · Franklin, WIBuilt 1940 · S/N CA12321
Back to AD 47-30-08