Skip to content

Fairchild M-62A

Registered aircraft · 116

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 ('3371604')
  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 ('3371604')
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.

N1110RCalifornia Flight Museum · Coronado, CABuilt 1942 · S/N T42-3872 N11161Gonzales Donald M · Columbia Station, OHBuilt 1946 · S/N T43-4549 N119ECMid Atlantic Air Museum · Reading, PABuilt 1940 · S/N T40-308 N11CMDay Leslie · San Diego, CABuilt 1949 · S/N 9884AE N127MPKelly Michael P · Coldwater, MIBuilt 1943 · S/N T43-5846 N129PTTsi Holdco Inc · Virginia Beach, VABuilt 1943 · S/N T43-7230 N157PTLaing Malcolm · Lubbock, TXS/N T42-3150 N1594VTennis Gayland L · Bath, MIS/N T434547 N1777Harrington Mark A · West Milford, NJBuilt 1942 · S/N T42-3629 N193ARCorsicana Field Aviation Heritage Foundation · Rice, TXBuilt 1943 · S/N T43-7155 N1941NLone Star Flight Museum · Houston, TXBuilt 1941 · S/N T41-1184 N19PTMoore George C Sr · Fincastle, VAS/N T41-572 N19RHMartin James L · South Bend, INBuilt 1943 · S/N 7583AE N19WRMitchells & Mosquitos LLC · Latham, NYS/N 9504AE N3184MMorgan Richard D · Belton, TXBuilt 1943 · S/N 7403AE N323CJKuhnert Michael C · Topping, VABuilt 1943 · S/N T43-5778 N33176Hauck Dennis J · Crawfordsville, INBuilt 1944 · S/N 10424-AE N33870Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1940 · S/N T-40-237 N363AEEichhorn Adrian A · Mclean, VABuilt 1945 · S/N T43-7208 N4119AManning Philip J · Melbourne, FLBuilt 1941 · S/N T41-1048 N439EWImlay Ryan E · Livermore, CABuilt 1943 · S/N T43-4498 N46197Fagen Roland J · Granite Falls, MNS/N T43-7272 N46199Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1944 · S/N T43-7274 N462XPThomas Robert S · Caddo Mills, TXS/N T41-730 N464BCCaldwell Collection Inc · Oklahoma City, OKBuilt 1942 · S/N 253 N46876American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T421957 N46881Riffle Brian W · Auburn, WABuilt 1943 · S/N T435426 N47015Mohr Charles F · Buffalo, NYRegistration revokedBuilt 1943 · S/N 4435792 N47117Bauer Aviation LLC · Reese, MIBuilt 1943 · S/N T43-5397 N47154Williamson Rolla Charles Jr · East Falmouth, MARegistration revokedBuilt 1943 · S/N 7283AE N47158Jorgensen Jeremiah D · Elizabethtown, KYBuilt 1943 · S/N T43-7428 N47279Emmons Donald R · Flint, MIRegistration revokedBuilt 1940 · S/N T40392 N47397Discoe Alexander · Kingsburg, CARegistration revokedBuilt 1941 · S/N T411274 N47439Welch Raymond · Elgin, ILRegistration revokedBuilt 1943 · S/N 5233AE N47747Walk Michael J · Englewood, FLBuilt 1943 · S/N T43-5488 N47803Yanks Air Museum · Baldwin Park, CABuilt 1943 · S/N 8163AE N47922Nelson Flying Service Inc · Sidney, NEBuilt 1943 · S/N 8063AE N47986Daniel Hardy L Jr · Derby, KSS/N T42-3157 N48047Daniel Hardy L Jr · Derby, KSS/N 6803AE N48144Farley Sarah A · Rice, TXBuilt 1943 · S/N T43-7042 N48154Sale Reported · Redlands, CASale reportedBuilt 1943 · S/N T437053 N48328Mojo Aerospace LLC · Wilmington, DEBuilt 1945 · S/N 7263AE N48488Busha James P · Oshkosh, WIBuilt 1943 · S/N T435751 N48671Acme Flyers LLC · Austin, TXBuilt 1941 · S/N T41-1191 N48705Chi Aerospace Inc · Portsmouth, NHBuilt 1943 · S/N 7493AE N49071Hawaii Warbirds Inc · Honolulu, HIBuilt 1943 · S/N T43-5310 N49232Casa Acquisitions LLC · Winter Haven, FLS/N T43-5055 N49238American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T42-3530 N49795Hammond James F · Yellow Springs, OHBuilt 1941 · S/N T411222 N49797American Airpower Heritage Flying Museum · Dallas, TXBuilt 1945 · S/N T42-3273

Back to Fairchild M-62A