OpenAirDocs.org
Troy, MO

Registered aircraft · 47

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 = 'TROY'
  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.

N1200MSmith Mike G HELICYCLE · S/N 5-12B512EBell John JN12825Macdonald CHEROKEE II · S/N DMP-1Built 1963 · Baldwin Dale AN1318NDJI AGRAS T40 · S/N 64TBKBC002002KHall Ag Services LLCN14014Waco YKC · S/N 3878Built 1934 · Alexander David LN15103Firefly Balloons FIREFLY 7B-15 · S/N F7B-2001Built 2001 · Jagust William MN173AFLindstrand Balloons 90A · S/N 173Shafer Brian AN19126Fairchild 24 H · S/N 3221Built 1937 · Seifert Richard EN24907Piper J3C-65 · S/N 3529Built 1939 · Tracy Johnny LN2496LCessna 172H · S/N 17255696Built 1966 · Sequeira Michael JN314BACessna 182F · S/N 18254547Built 1962 · Comer JacobN31JMMiller James D RV7 · S/N 71203Built 2004 · Veile JosephN3372EAeronca 7AC · S/N 7AC-6798Built 1947 · Tracy Johnny LN37DDDavid G Domeier RV-8 · S/N 83261Built 2014 · Baldwin Dale AN38170Piper J-3C · S/N 6838Built 1941 · Kisela Andrew JN41103Piper J3L-65 · S/N 7652Built 1941 · Baldwin Frank DN4632CCessna 170B · S/N 25576Built 1953 · Baldwin Dale AN49159Cessna 152 · S/N 15281172Built 1977 · Comer Jacob WN5086ZPiper PA-22-108 · S/N 22-8718Built 1961 · Richards Curtis AN5181GCessna 305A · S/N 22234Built 1951 · Walton Daniel GN527KADJI AGRAS T100 · S/N 1581F8ZLC258N002P9M1Hall Ag Services LLCN528VHDJI AGRAS T100 · S/N 1581F8ZLC25870029VCFHall Ag Services LLCN547SBBell 47G · S/N 5Built 1954 · Sequeira Michael JN600HHHenderson THORP T-18 · S/N 600Built 1974 · Fleming Mike RN611DMEaa SPORT BIPLANE · S/N 001-RMBuilt 1976 · Fildes RobertN613MBrewster FLEET 2 · S/N 189Built 1929 · Jacobson Diana MN620DPDJI AGRAS T100 · S/N 1581F8ZLC25AR002HEV4Hall Ag Services LLCN6284VBeech V35A · S/N D-8605Built 1967 · Bradsher Harold MichaelN65520Bell 47G-2 · S/N 2012Sale reportedBuilt 1957N6962XCessna 172B · S/N 17247862Built 1960 · Bradsher Harold MN701MLHarold M Bradsher CH 701 · S/N 7-5955Bradsher Harold MN705BTTalir Robert J TA-2 FLIGHTSTAR II · S/N 402Built 2010 · Talir Robert JN707BFFrohm Bob RV-6 · S/N 25851Built 2009 · Bradsher Harold MN7082KBalloon Works FIREFLY 7B-15 · S/N F7B-385Built 1999 · Gebhart Preston RN7153HCantrell Jimmy A RV-6A · S/N 20393Built 1990 · Glaser Donald L IIIN7210DPiper PA-22-150 · S/N 22-5034Built 1957 · Rainey Lee SN72VPCummins EVANS WE-1 · S/N 1ABuilt 1972 · Jagust William MN758JZCessna R172K · S/N R1723145Built 1979 · Reaka Dean James TrusteeN7748DPiper PA-22-150 · S/N 22-5428Built 1957 · Jagust William MN778LBLindstrand Balloons 77A · S/N 5341Built 2006 · Mueller Scott AN8133BCessna 172 · S/N 29933Built 1957 · Reaka Dean James TrusteeN813EDBaldwin Dale KR-2 · S/N 942Baldwin Dale AN8204TCessna 175B · S/N 17556904Built 1960 · Champion Anthony RN8339ZPiper PA-32-301T · S/N 32-8124013Built 1981 · Letendre Brian PaulN8370PPiper PA-24 · S/N 24-3628Built 1964 · Donovan Patrick DN8521AHimburg Carl Edward PITTS SPECIAL S-1C · S/N XP1-EHBaldwin Frank DN895HADJI AGRAS T100 · S/N 1581F8ZLC258L00275YWHall Ag Services LLCN930HADJI AGRAS T100 · S/N 1581F8ZLC256A00291JWHall Ag Services LLC
Back to Troy, MO