OpenAirDocs.org
AD 48-34-01

Registered aircraft · 68

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:48-34-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-34-01')
  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.

N103GClifford Michael P · Paris, TXBuilt 1950 · S/N A533N1047BAlaska Aviation Museum · Anchorage, AKS/N 7728N1140Beechboys Aviation LLC · Wilmington, DEBuilt 1946 · S/N A-129N118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235N1801DKlaers Lawrence B · Waconia, MNBuilt 1952 · S/N A-816N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361N218HCInvader Leasing LLC · Kingsford, MIS/N 8281N21CAJorgensen Bryan H · Wadsworth, OHBuilt 1946 · S/N A-250N223CMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA223N23DFSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1944 · S/N 6220N2913BW Air Collection Inc Trustee · Wilmington, DEBuilt 1953 · S/N A-963N30GAg Air Inc · Matthews, MOBuilt 1946 · S/N A-131N3111Setter Thomas D · Burnsville, MNBuilt 1953 · S/N A-964N33JPScenic Flight Adventures LLC · Coeur D Alene, IDBuilt 1954 · S/N A-998N3500BWalter Charles T Jr · Ocala, FLBuilt 1953 · S/N A-973N3532BPlane Crazy Aviation LLC · Hollywood, SCBuilt 1954 · S/N A-999N411JAukes Brian E · Huxley, IABuilt 1953 · S/N A-967N41289Nizex Inc · Jackson, GAS/N A-475N412KKourtis Vintage Aviation LLC · Owasso, OKBuilt 1946 · S/N A-263N42114Spiller Gary W · Lafayette, ORS/N 39815N42CStage One Associates LLC · Oxford, CTS/N A-468N4356GTop Hand Inc · Laurel, MTBuilt 1951 · S/N CA56N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26N44573Adventure North Flying Service LLC · Baudette, MNBuilt 1944 · S/N 7678N44607Shepard Group LLC · Mena, ARBuilt 1945 · S/N A-15N44638Vintage Aircraft Inc · Stockton, CAS/N A-45N4477Parish John Sr · Tullahoma, TNBuilt 1952 · S/N A-935N4910NJackson James E · Brainerd, MNS/N 8382N4DHGlenn L Martin Maryland Aviation Museum · Baltimore, MDBuilt 1946 · S/N A-260N52DNAir Apparent Aviation LLC · Plant City, FLBuilt 1952 · S/N A-846N5552AAllen Chorman & Son Inc · Milton, DEBuilt 1944 · S/N 8431N5804CGeorge Andrew N · Corvallis, ORBuilt 1951 · S/N A579N5QQBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N A-223N6047VWiplinger Robert D · Inver Grove Hgts, MNBuilt 1944 · S/N 8151N62936Prop And Jet Air Museum · Romoland, CAS/N CA38N64463Air Combat Museum · Springfield, ILBuilt 1943 · S/N 4534N649BSpirit Engineering Inc · Grand Junction, COBuilt 1948 · S/N A-454N651BSjc IV LLC · Lawrence, KSBuilt 1949 · S/N A-478N6623Szostak Edward M · San Diego, CABuilt 1946 · S/N A-295N67929Ladd Daniel T · Loudon, NHBuilt 1945 · S/N 6430N69044Cross Brian K · Winters, CABuilt 1943 · S/N 4781N6BAMcmanigle Jeff · Osakis, MNBuilt 1946 · S/N A-406N70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1966 · S/N A-177N70WWIsland City Seaplanes Inc · Cordova, AKS/N A-38N73548Smith Salvage And Restoration Services LLC · New Berlin, TXS/N A-548N75JCWilliams Austin · Valdosta, GABuilt 1946 · S/N A-256
Back to AD 48-34-01