Missouri City, TX
Registered aircraft · 45
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 = 'TX' AND g.registrant_city = 'MISSOURI CITY' 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.
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 = 'TX' AND g.registrant_city = 'MISSOURI CITY' ORDER BY g.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.
N110JWGulfstream Aerospace G-IV · S/N 1245N119TCRaytheon 400A · S/N RK-297N13YNRobert J Karow REBEL · S/N 001N15410Piper PA-28-235 · S/N 28-7310043N16BJPiper PA-32RT-300T · S/N 32R-7987115N177BBGulfstream Aerospace G-IV · S/N 1073N2465ECessna 172N · S/N 17271292N2513PPiper PA-22-150 · S/N 22-2875N2516LCessna 172H · S/N 17255716N26256Grumman American Avn. AA-5A · S/N AA5A0487N281CPCirrus Design SR22 · S/N 3181N28809Grumman American Avn. AA-5B · S/N AA5B0833N310GCCessna T310Q · S/N 310Q0838N340AMCessna 340A · S/N 340A0278N3795TPiper PA-28R-180 · S/N 28R-30108N3YUCessna 182T · S/N 18281453N414WRCessna 414A · S/N 414A0247N461JGGosch Jerry L RV-6 · S/N 22019N48ALCessna T210M · S/N 21061658N4GLCessna 182P · S/N 18262723N515SMCirrus Design SR22 · S/N 8500N5190EAirborne Windsports EDGE XT 912 · S/N XT 912-012N57309Piper PA-28-140 · S/N 28-7425088N57MTCessna 210C · S/N 21058133N607JJabiru USA Sport J250-SP · S/N 455N612XCessna T182T · S/N T18208202N721HBCessna 421C · S/N 421C0629N8124PCirrus Design SR22 · S/N 0651N81303Grumman American Avn. AA-5B · S/N AA5B0489N817LABeech A36 · S/N E-2852N830TXTexas Aircraft Mfg COLT 100 · S/N TXA007N83133Boeing A75N1(PT17) · S/N 75-1466N8317RLynch Gerald Craig RV-6 VANS · S/N 60490N83562Piper PA-34-220T · S/N 34-8133042N8688AAir Command SINGLE PL GYROPLANE · S/N 001N8688MMusa Aziz Khalil TANGO 2 · S/N 000014N88521Cessna 340A · S/N 340A1260N88QKTurner Victor E JR VARIEZE · S/N 964N8954NPiper PA-32-300 · S/N 32-40757N9135WMooney M20J · S/N 24-3228First renewal noticeN9568MMooney M20F · S/N 670145N96282Taylorcraft BC12-D · S/N 8582N9750QCessna 172M · S/N 17265789N9787RBeech M35 · S/N D-6303N98189Cessna R172E · S/N R172-0244
Back to Missouri City, TX