OpenAirDocs.org
O Fallon, MO

Registered aircraft · 180

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'MO' AND g.registrant_city = 'O FALLON'
  ORDER BY g.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.

N101AEBell Helicopter Textron 206L-1 · S/N 45454Built 1980 · Air Evac Ems IncN103AEBell Helicopter Textron 206L-1 · S/N 45597Built 1981 · Air Evac Ems IncN106AEBell Helicopter Textron 206L-1 · S/N 45566Built 1981 · Air Evac Ems IncN109GRAirbus Helicopters EC 130 T2 · S/N 9650Built 2024 · Air Evac Ems IncN113AEBell Helicopter Textron 206L-1 · S/N 45371Air Evac Ems IncN118AEBell Helicopter Textron 206L-1 · S/N 45724Built 1981 · Air Evac Ems IncN119AEBell 206L-3 · S/N 51201Built 1981 · Air Evac Ems IncN124AEBell 206L-3 · S/N 51591Built 1992 · Air Evac Ems IncN12AEBell Helicopter Textron 206L-1 · S/N 45649Built 1981 · Air Evac Ems IncN130AEBell Helicopter Textron 206L-1 · S/N 45467Built 1980 · Air Evac Ems IncN132AEBell Helicopter Textron 206L-1 · S/N 45491Built 1980 · Air Evac Ems IncN133AEBell Helicopter Textron 206L-1 · S/N 45280Built 1979 · Air Evac Ems IncN134AEBell Helicopter Textron 206L-1 · S/N 45593Built 1981 · Air Evac Ems IncN138AEBell Helicopter Textron 206L-1 · S/N 45782Built 1983 · Air Evac Ems IncN13AMAshton Kent J ASHTON COZY MARK IV · S/N 150Built 2002 · Anderson Kevin RN1883TPiper PA-28-140 · S/N 28-7225038Built 1971 · Wilkins Joseph KN192AEBell Helicopter Textron 206L-1 · S/N 45660Air Evac Ems IncN196AEBell Helicopter Textron Canada 407 · S/N 54858Built 2019 · Air Evac Ems IncN2238GPiper PA-28-181 · S/N 28-7990418Built 1979 · Rupp Aviation LLCN225AEBell Helicopter Textron 206L-1 · S/N 45577Air Evac Ems IncN228MTEurocopter Deutschland EC 135 P2+ · S/N 0908Built 2010 · Air Evac Ems IncN229AEBell Helicopter Textron 206L-1 · S/N 45256Air Evac Ems IncN233AEBell 206L-3 · S/N 51453Built 1991 · Air Evac Ems IncN239AEBell Helicopter Textron 206L-1 · S/N 45367Built 1980 · Air Evac Ems IncN24662Beech A24R · S/N MC-139Built 1973 · Dumay ChadN248AEBell 206L-3 · S/N 51129Built 1985 · Air Evac Ems IncN249WHBeech F33C · S/N CJ-147Built 1978 · Whiskey Hotel LLCN24AEBell Helicopter Textron 206L-1 · S/N 45646Built 1981 · Air Evac Ems IncN24BJWasson Brian P/Wasson Julie N RV10 · S/N 42007Built 2026 · Wasson Brian PN258AEBell Helicopter Textron 206L-1 · S/N 45578Built 1980 · Air Evac Ems IncN269AEBell 206L-3 · S/N 51530Built 1991 · Air Evac Ems IncN274AEBell Helicopter Textron 206L-1 · S/N 45762Built 1983 · Air Evac Ems IncN275AEBell 206L-3 · S/N 51186Built 1986 · Air Evac Ems IncN277AEBell 206L-3 · S/N 51421Built 1990 · Air Evac Ems IncN27AEBell Helicopter Textron 206L-1 · S/N 45192Built 1978 · Air Evac Ems IncN281AEBell 206L-3 · S/N 51451Built 1991 · Air Evac Ems IncN285AEBell 206L-3 · S/N 51550Built 1992 · Air Evac Ems IncN288AEBell 206L-3 · S/N 51327Built 1989 · Air Evac Ems IncN290AEBell 206L-3 · S/N 51192Built 1986 · Air Evac Ems IncN292AEBell Helicopter Textron 206L-1 · S/N 45780Built 1983 · Air Evac Ems IncN293AEBell 206L-3 · S/N 51476Built 1992 · Air Evac Ems IncN294GRBell Textron Canada 407 · S/N 56495Air Evac Ems IncN295AEBell 206L-3 · S/N 51455Built 1991 · Air Evac Ems IncN295GRBell Textron Canada 407 · S/N 56497Registration pendingN296AEBell Helicopter Textron 206L-1 · S/N 45398Built 1980 · Air Evac Ems IncN299AEBell Helicopter Textron 206L-1 · S/N 45621Built 1981 · Air Evac Ems IncN29AEBell 206L-3 · S/N 51191Built 1986 · Air Evac Ems IncN311AEBell Helicopter Textron 206L-1 · S/N 45572Air Evac Ems IncN314AEBell 206-L4 · S/N 52222Built 1999 · Air Evac Ems IncN315AEBell Helicopter Textron 206L-1 · S/N 45482Built 1980 · Air Evac Ems Inc
Back to O Fallon, MO