Odessa, TX
Registered aircraft · 94
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 = 'ODESSA' 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 = 'ODESSA' 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.
N137AJAndrew Rolls SLING TSI · S/N 383SKN1424KLuscombe 8A · S/N 4151Registration revokedN144EHRobinson Helicopter R44 II · S/N 10742N144MNRobinson Helicopter R44 · S/N 1555N180SWCessna 180E · S/N 18051069N1812WBeech E-55 · S/N TE-894N1987MPiper PA 46-350P · S/N 4636872N19JJJones James A PITTS S-1E · S/N 450663433-1N19THHood Timothy L KITFOX SERIES 5 · S/N S96060179N2087APiper PA-32RT-300T · S/N 32R-7987001First renewal noticeN2215KLuscombe 8A · S/N 4942N222DACessna 560 · S/N 5600202N227RJCessna 182S · S/N 18280383N22HAPiper PA-28RT-201 · S/N 28R-7918053N2356LCessna 182S · S/N 18280425N238EJCessna 550 · S/N 550-0812N2406XBrumit John C JR GALAXY · S/N 01N248DCAir Creation BUGGY 582 · S/N T03004N24MYSocata TBM 700 · S/N 1143N26159Cessna 150L · S/N 15073511N2673FHughes Aero PREDATOR "C" · S/N PC010853W407N26DDDonar Francis E/Donar David J DAVIS-DA-2-A · S/N 137N2723DCessna 170B · S/N 25265N27TBeech A36 · S/N E-1783N2905LMooney M20F · S/N 670299N306FLEmbraer-Empresa Brasileira De EMB-505 · S/N 50500030N3114MPiper PA-12 · S/N 12-1807N3387VBeech 35 · S/N D-861N3425UCessna 182F · S/N 18254825N3585WPiper PA-32-260 · S/N 32-479N36NMBeech B36TC · S/N EA-316N3734APiper PA-22-135 · S/N 22-1977N3755QPiper PA-28R-201T · S/N 28R-7703116N378WTCirrus Design SR22T · S/N 0882N39568Piper PA-28R-201T · S/N 28R-7803355N4071HMooney M20J · S/N 24-1050N407RRBell 407 · S/N 54332N414FGCessna 414A · S/N 414A0814N425WGCessna 425 · S/N 425-0030N429BZCubcrafters CC11-160 · S/N CC11-00299N432PCRobinson Helicopter R44 II · S/N 13019N438SATextron 182T · S/N 18282421N448STPiper PA 46-350P · S/N 4636448N456BWCessna T207 · S/N 20700298N4631CCessna T210N · S/N 21063582N473FCLearjet 60 · S/N 322N47668Aeronca 0-58B · S/N 058B-4942N508SBCirrus Design SR22T · S/N 0361N508TCCessna T210N · S/N 21064741N511BWQuartz Mountain Aerospace 11E · S/N 1013
Back to Odessa, TX