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.

N3703FPresby Aire LLC · Berlin, NHBuilt 1976 · S/N 0738N3705FMonteith Andrew W · Lebanon, PABuilt 1977 · S/N 0750N371PFInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 0743N3731FCarder Wiley C · Cameron Park, CABuilt 1976 · S/N 0746N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755N3751FAdrion Advisors Inc · Winter Haven, FLBuilt 1977 · S/N 0756N3759FCoates Joseph M Jr · Tallapoosa, GABuilt 1977 · S/N 0757N3763FSmith Herbert L · Brandon, MSBuilt 1977 · S/N 0759N3765FSalton Robert L · Charlotte, NCBuilt 1977 · S/N 0760N3771FCrane John R · Niceville, FLS/N 0764N3775FHickle William H · Inyokern, CABuilt 1977 · S/N 0766N37WRStill Flying LLC · Carlisle, PABuilt 1975 · S/N 0721N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778N3812FGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1977 · S/N 0780N3813FN3813f Inc · Wilmington, DEBuilt 1977 · S/N 0781N3814FSnuffer Michael K · Reno, NVBuilt 1977 · S/N 0782N3815FOrr Charles W III · San Ramon, CABuilt 1977 · S/N 0783N3816FHotzel Jeffrey F · Gladstone, MOBuilt 1977 · S/N 0784N3817FKirker Howard A · Rio Verde, AZS/N 0785N3819FBuntings Grassroots Aviation LLC · Selbyville, DEFirst renewal noticeS/N 0787N3821FKennedy Karen E · Gulf Breeze, FLBuilt 1977 · S/N 0789N3822FBelser Mark · Avon, OHBuilt 1977 · S/N 0790N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791N390HKlubichek Janet C · Winnemucca, NVBuilt 1972 · S/N 67717-F-331N4008LBooth James L · Bozeman, MTS/N 0824N4011LSmith Jeffrey S · Linden, MIBuilt 1978 · S/N 0825N434RBBrown Brian M · Downey, CABuilt 1976 · S/N 0740N435YGreat Lakes Aircraft LLC · Palmer Lake, COS/N 152N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752N4555WSan Diego Aerobatics LLC · San Diego, CABuilt 1976 · S/N 0741N455ETLakes Aircraft Inc. · Maumee, OHBuilt 1975 · S/N 0711N464JWWatts John C · Matthews, NCBuilt 2023 · S/N 1219N474CTThomas Wayne H · Dover, DEBuilt 1981 · S/N 1002N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770N501GLSharp Aviation LLC · Pauls Valley, OKBuilt 1973 · S/N 0501N502GLSky Dancing LLC · La Jolla, CABuilt 1973 · S/N 0502N503GLWomack Thomas G · Lonoke, ARS/N 0503N506GLKutschera Theodore C III · Callicoon, NYBuilt 1973 · S/N 0506N507GLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 507N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508N511GLFrerichs Brent A · Sandpoint, IDBuilt 1975 · S/N 0511N521KD S Batchelor Holdings LLC · Clark, SDBuilt 1998 · S/N 2JFN52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761N530HSCti Aircraft Leasing LLC · Memphis, TNBuilt 2014 · S/N 1205
Back to AD 2012-11-08