Skip to content

Fairchild M-62A-3

Registered aircraft · 56

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('3371618')
  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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('3371618')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N103JCAmerican Air Power Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N FC-119 N1094MSartori Luciano · Windermere, FLBuilt 1943 · S/N T43-4470 N1132N1941 Historical Aircraft Group Museum DBA · Geneseo, NYBuilt 1942 · S/N FC-27 N1175NHistoric Flights Foundation Corp · Kokomo, INS/N FT-635 N128PTOwens Wilbur · Rch Palos Vrd, CABuilt 1942 · S/N FT735 N26PTOld Aeroplane Co LLC · Fort Ogden, FLS/N T43-4513 N39681Price Donald N · Houston, TXS/N FV133 N46389Boggs Wayne G · Tampa, FLBuilt 1943 · S/N T43-5311 N464ZMManning Mark B · Bridport, VTS/N T42-4047 N46836Planes Of Fame Air Museum · Chino, CAS/N FV703 N4732GAmerican Airpower Heritage Flying Mu · Dallas, TXBuilt 1965 · S/N 10846 N48841Riffle George W · Auburn, WABuilt 1941 · S/N T41-997 N49481Fleeman Joseph R · Lawrenceburg, TNBuilt 1942 · S/N FV162 N50175Obowa Denis J · Fergus Falls, MNBuilt 1943 · S/N T43-5301 N51090Butler County Warbirds Inc · Middletown, OHBuilt 1943 · S/N T43-5048 N519SHAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1943 · S/N T-435954 N52079American Airpower Heritage Flying Museum · Dallas, TXS/N FT-782 N526PTKyler Chris K · Meridian, MSBuilt 1943 · S/N FC-47 N53279Leverich James E · Pampa, TXBuilt 1943 · S/N T43-5589 N54254Craig Robert A · West Chester, PABuilt 1941 · S/N T-42-1831 N5519NAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1944 · S/N FC-18 N58108Hamilton Robert J · Perry, GABuilt 1943 · S/N FC-179 N58749Mendenhall James W Trustee · Anchorage, AKS/N T42-4191 N58799Egmond Aircraft LLC · Lewes, DEBuilt 1943 · S/N FV-154 N58810Texas Air Museum · Slaton, TXS/N FT825 N58894Vintage Flying Machines Inc · Huntington, INBuilt 1946 · S/N FT-737 N60385Henderson Douglas T · Mulino, ORBuilt 1943 · S/N FV-454 N60535American Airpower Heritage Fly Musm · Dallas, TXBuilt 1945 · S/N FX-146 N6072CAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1954 · S/N 42-65935 N63568Fairchild Aircraft LLC · Dover, DEBuilt 1943 · S/N T43-4499 N6587DCanterbury Greg · Daniel Island, SCS/N FT-643 N67523Crnic Paul · Chesterfield, MOBuilt 1943 · S/N FV152 N67616Inzana Anthony F II · Hughson, CABuilt 1943 · S/N FV123 N68150Mehrer Fritz J · El Cajon, CABuilt 1943 · S/N T43-4496 N68210Imlay Ryan E · Livermore, CAS/N FA443 N69167Chico Air Museum · Chico, CABuilt 1943 · S/N FV-342 N69256Reichert John A · Rehoboth Beach, DEBuilt 1944 · S/N FV-257 N69262Planes Of Fame Air Museum · Chino, CABuilt 1943 · S/N FT-683 N73327Harris Kenneth L · Greeley, COBuilt 1946 · S/N FV-664 N73521American Airpower Heritage Flying Museum · Dallas, TXS/N T43-4450 N73529Shokoui Kourosh C · Panama City, FLBuilt 1943 · S/N T43-4456 N74621Military Aviation Museum · Virginia Beach, VABuilt 1959 · S/N T43-4503 N75LDGroup 44 Fairchild LLC · Dallas, TXS/N FT-715 N770YJts Aircraft LLC · Rock Hill, SCS/N FT-718 N79109Wilson John C · Malabar, FLBuilt 1944 · S/N FX-189 N79307Trimble Timothy A · Lancaster, PABuilt 1943 · S/N FZ-337 N79398Henderson Douglas T · Mulino, ORBuilt 1943 · S/N FV-112 N9165HFarwest Aviation LLC · Billings, MTBuilt 1943 · S/N T43-4459 N9198HVon Bevern Brian J · Overland Park, KSBuilt 1944 · S/N FZ-260 N9227HJeffers Andrew T · Springfield, OHBuilt 1943 · S/N FV258

Back to Fairchild M-62A-3