OpenAirDocs.org
AD 2012-11-08

Registered aircraft · 177

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:2012-11-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:2012-11-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.

N100GLWaco Aircraft Corp · Battle Creek, MIBuilt 2021 · S/N 1215N101GLAssociated Aircraft LLC · San Diego, CAS/N 0714N112PTGreat Lakes Bp LLC · Cranston, RIS/N 0808N1130HEnking Novak Teresa M · North Fond Du Lac, WIBuilt 1931 · S/N 253N11324Madden William L · Las Cruces, NMBuilt 1931 · S/N 241N11326Singer Saul Aaron · Sausalito, CAS/N 243N11333Great Lakes Aircraft LLC · Palmer Lake, COBuilt 1931 · S/N 246N11334Martin James David · Graford, TXBuilt 1931 · S/N 247N11336Kushnir Bo · Tamuning, GUS/N 249N11337Harris Hayden H · Chelsea, MIS/N 250N11338Hofmann John M · Columbus, WIBuilt 1931 · S/N 251N11339Airpower Museum Inc · Ottumwa, IABuilt 1932 · S/N 252N128PHWayne Terry · Belews Creek, NCBuilt 2023 · S/N 1218N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N14JVFullen Ronnie E · Seguin, TXBuilt 1977 · S/N 0749N15GLTubb Jeffrey Scott · Farmington, NMBuilt 2016 · S/N 1209N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814N16GLDuncan David · Colorado Springs, COS/N 0772N175HDEdens Kenneth L · Hot Springs, ARBuilt 1975 · S/N 0708N1XGClass A Coaches LLC · Missoula, MTBuilt 1981 · S/N 1001N204GLChrist Robert D · Mandeville, LABuilt 2014 · S/N 1204N204KBradley Gary C · Orchard Park, NYBuilt 1929 · S/N 30N21GLBuntings Grassroots Aviation LLC · Selbyville, DEBuilt 2013 · S/N 1200N21XGPrivitt Bret · Hudson Oaks, TXBuilt 1982 · S/N 1007N22LBComchoc Paul R · Bellevue, WABuilt 1976 · S/N 0730N240DGGubert David A · Saint Johns, MIBuilt 2014 · S/N 1202N24CManganaro Andrew J · Xenia, OHBuilt 1985 · S/N 1011N252TTRex Ron · Ocala, FLBuilt 2015 · S/N 1208N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211N2XGFrisch John W III · Chicago, ILBuilt 1980 · S/N 0830N333HMcintyre Wayne F · Pebble Beach, CABuilt 1928 · S/N 136N3502LNatale William F · Saratoga Springs, NYBuilt 1978 · S/N 0792N3511LPatty Brent A · El Dorado, KSBuilt 1978 · S/N 0793N3513LDuden Brett R · Golden, COBuilt 1978 · S/N 0795N3514LFlying Horseman Ranch LLC · Stuart, VABuilt 1978 · S/N 0796N3515LBorchers Bruce A · Scotts Valley, CAS/N 0797N3544LLabounty Dana G · Sumter, SCBuilt 1978 · S/N 0800N3554LHarding Nelson · Lebanon, ORBuilt 1978 · S/N 0801N3564LShepherd William M · Virginia Beach, VABuilt 1978 · S/N 0803N3567LGordon Robert E Jr · Holly Springs, NCBuilt 1978 · S/N 0805N3587LVanatta J Dennis · Faribault, MNBuilt 1978 · S/N 0809N3604LWalker Carol L · Ennis, TXBuilt 1978 · S/N 0812N3604XJones Bryan David Kingsley · San Diego, CABuilt 1977 · S/N 0767N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817N3673LM&M Shipshape LLC · Kalispell, MTBuilt 1978 · S/N 0820N3676LGeantil Thomas G · San Diego, CABuilt 1978 · S/N 0821N3678LAerojet Services Inc · Aurora, COBuilt 1978 · S/N 0822N3684LLucke Eva DBA · Minot, NDBuilt 1978 · S/N 0819N3702FBuzjob Aviation LLC · Los Angeles, CABuilt 1976 · S/N 0739
Back to AD 2012-11-08