OpenAirDocs.org
AD 47-51-12

Registered aircraft · 45

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-51-12')
    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-51-12')
  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.

N105CAChampaign Aviation Museum · Urbana, OHBuilt 1944 · S/N 25720N115NABasler Turbo Conversions LLC · Oshkosh, WIS/N 11625N115SABasler Turbo Conversions LLC · Oshkosh, WIS/N 13310N130DQuigg Gary F · Crawfordsville, INBuilt 1943 · S/N 19800N1350AAlaska Skypower LLC · Fairbanks, AKBuilt 1944 · S/N 33032N138DMuseum Of Flight Foundation · Seattle, WABuilt 1940 · S/N 2245N141JRThirsty 13th LLC · Dallas, TXBuilt 1944 · S/N 19366N150DQualitair LLC Trustee · MichelstadtBuilt 1941 · S/N 4463N15MAFlorida Air Cargo · Davie, FLBuilt 1942 · S/N 19286N16005N1944m LLC · Wilmington, DEBuilt 1942 · S/N 19394N167TWBasler Turbo Conversions LLC · Oshkosh, WIS/N 26005N1944AWeeks Kermit A · Polk City, FLBuilt 1944 · S/N 19677N1XPDuggy Foundation · Page, NDBuilt 1942 · S/N 4733N25641Jb Air Services LLC · Brighton, COBuilt 1943 · S/N 9059N271SEFlorida Air Cargo Inc · Davie, FLBuilt 1945 · S/N 15676/27121N2805JAmerican Flight Museum Inc · Topeka, KSBuilt 1944 · S/N 20835N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744N300MFMissionary Flights And Services Inc DBA · Fort Pierce, FLBuilt 1944 · S/N 32961N3239TValiant Air Command Inc · Titusville, FLBuilt 1987 · S/N 19054N33623Dakota Aviation Museum Inc · Mason, NHBuilt 1944 · S/N 20215N33VWKourtis Vintage Aviation LLC · Owasso, OKS/N 20401N345AB1941 Historical Aircraft Group Museum · Geneseo, NYBuilt 1943 · S/N 13803N346ABAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1945 · S/N 16693N431HMPlane Fun Inc Tr Trustee · Snellville, GAS/N 9995N472AFVintage Wings Aircraft LLC · Center Point, INBuilt 1944 · S/N 13485N5106XPleasant Aviation LLC · Mount Pleasant, TXBuilt 1943 · S/N 9058N566PTPriority Air Charter LLC · Kidron, OHBuilt 1944 · S/N 13346N574JBWar Eagles Air Museum · Santa Teresa, NMBuilt 1944 · S/N 20145N57626Nord Aviation Inc · Pembina, NDBuilt 1943 · S/N 4564N60154Palm Springs Air Museum · Palm Springs, CABuilt 1943 · S/N 32755N63440Alaska Crew Inc · Anchorage, AKS/N 20194N64784Cleveland Detroit Flying Service LLC · Solvang, CAS/N 14037N74589Tunison Foundation Inc · Oxford, CTBuilt 1942 · S/N 9926N791HHMartin Aviation Inc · Santa Ana, CABuilt 1944 · S/N 33123N844THN844th LLC · California, MDBuilt 1944 · S/N 13070N856KBBasler Turbo Conversions LLC · Oshkosh, WIS/N 12597N856LTBasler Turbo Conversions LLC · Oshkosh, WIS/N 25612N856QBBasler Turbo Conversions LLC · Oshkosh, WIS/N 4785N856YBBasler Turbo Conversions LLC · Oshkosh, WIS/N 9089N8704Yankee Air Force Inc · Belleville, MIBuilt 1944 · S/N 33048N877MGPeters Gary · Clarkston, WABuilt 1949 · S/N 20806N882TPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1945 · S/N 32644N8WJStonehenge Air Museum Inc · Kalispell, MTBuilt 1942 · S/N 9276N941ATBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1942 · S/N 12907 (42-93040)N983DCGreystone Housing Foundation Inc · San Diego, CABuilt 1942 · S/N 12267
Back to AD 47-51-12