Skip to content

Aero Commander 200D

Registered aircraft · 54

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

N111JRYoung Mark Allan · Sunnyvale, CABuilt 1967 · S/N 376 N123RLBastiano Richard A · Elba, NYBuilt 1966 · S/N 321 N15RRMcdonald Joseph T · Auburn, ALBuilt 1966 · S/N 332 N200DFlipper 1 LLC · Fort Lauderdale, FLBuilt 1967 · S/N 379 N201GMSundale Aviation Inc · Erwinna, PABuilt 1966 · S/N 312 N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380 N259MRidgerunner 51 LLC · Springdale, ARBuilt 1966 · S/N 297 N260MSmith David W · Milaca, MNS/N 298 N28PCGriesman Scott W · Sandy Valley, NVBuilt 1967 · S/N 377 N2900TEwing Richard Jr · Antelope, CABuilt 1966 · S/N 301 N2902THarber Gary · Melbourne, FLBuilt 1966 · S/N 303 N2905TZephyr Enterprises Inc · Wilmington, DEBuilt 1966 · S/N 306 N2908TRegistered aircraftBuilt 1966 · S/N 309 N2909TSmith David W · Milaca, MNS/N 314 N2912TKrahling Jeffrey B · Redding, CABuilt 1966 · S/N 318 N2913TBlaine Christopher · Friday Harbor, WABuilt 1966 · S/N 319 N2914TTp Aviation Inc · Augusta, KSBuilt 1966 · S/N 320 N2916TLewis Paul A · Spring, TXBuilt 1966 · S/N 322 N2919TParsons William Tony Jr · Medina, TNBuilt 1966 · S/N 325 N2943TN2943t LLC · Fort Myers, FLBuilt 1966 · S/N 346 N2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTBuilt 1966 · S/N 334 N2962TAviation Days LLC · Ridgefield, CTBuilt 1966 · S/N 335 N2964TMallard Aviation LLC · Manchester, NHBuilt 1966 · S/N 337 N2966TThomas Paul J · Oakland, MDBuilt 1966 · S/N 339 N2969TDoskicz Aircraft Specialties Inc · Bally, PABuilt 1966 · S/N 342 N2971TWhitfield Robert O Jr · Hurdle Mills, NCBuilt 1966 · S/N 343 N2972TTurnage Marvin E · Little Rock, ARBuilt 1966 · S/N 344 N2975TSmith David W · Milaca, MNS/N 348 N2976TMckay Ronye · Omaha, NEBuilt 1966 · S/N 349 N2979TMays Stephen W · Carson City, NVBuilt 1966 · S/N 345 N2980TMyers Thomas · Wills Point, TXBuilt 1966 · S/N 354 N2981TKool-E5 LLC · Valdosta, GABuilt 1966 · S/N 355 N2983TSlatter Lowell J · Buhl, IDBuilt 1966 · S/N 356 N2987TDaly Arthur P · El Paso, TXBuilt 1966 · S/N 360 N2988TSwiftmeyers LLC · Benton Harbor, MIBuilt 1966 · S/N 361 N2989TMid America Museum Of Aviation And Transportation · Sioux City, IABuilt 1966 · S/N 362 N2990TStahl Bradford C · Jackson, CAS/N 363 N2991TRothgeb Michael A · Burns, ORBuilt 1966 · S/N 364 N2992TMeyers 200 LLC · Malden, MOBuilt 1966 · S/N 365 N2993TElghammer Garrott W · Niles, MIBuilt 1967 · S/N 366 N2994TZakraisek Donald S · Sandy, UTBuilt 1967 · S/N 367 N2996TSims Barry Don Sr · Canadian, TXBuilt 1967 · S/N 369 N2998TMartony Joseph M · Chandler, AZBuilt 1967 · S/N 371 N31CCRegistered aircraftBuilt 1967 · S/N 370 N409ACHighland Holdings LLC · Bethlehem, PABuilt 1966 · S/N 336 N413KSMatteo Properties · Wickliffe, OHS/N 333 N418Vpropnw Inc · Walla Walla, WABuilt 1966 · S/N 359 N480S65 North Inc · Roswell, GABuilt 1967 · S/N 374 N5504MDaniel Richard L · La Habra Heights, CABuilt 1967 · S/N 375 N5507MVasenden Arnold V · Midlothian, TXBuilt 1967 · S/N 378

Back to Aero Commander 200D