Celina, TX
Registered aircraft · 38
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 = 'CELINA' 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 = 'CELINA' 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.
N102PAMooney International M20U · S/N 32-0007N133JDSwick-Bucker Jungmeister BU133S · S/N S2N15KFPiper PA-32-301 · S/N 32-8006073N212ACEADS CASA C-212-EE · S/N 470N212ADConstrucciones Aeronauticas CASA-212-200 · S/N 273N212BDEADS CASA C-212-EE · S/N 465N212PHEADS CASA C-212-EE · S/N 472N225FRCessna 172N · S/N 17273947N239JRCessna 208 · S/N 20800368N245MBeech H-18 · S/N BA-646N24SFHawker SEA FURY F B II · S/N 37517N2568QPiper PA-28-161 · S/N 28-7716113N28127Bellanca 17-30A · S/N 80-30972N34RHanson Gerald E LANCAIR LEGACY · S/N L2K-174N383DDawson F1 EVO · S/N 145N450ZRPiper PA-28-181 · S/N 2881481N4513BCessna 180 · S/N 31412N45LTBandt L Thaine CHRISTEN EAGLE II · S/N BANDT0001N499WTCessna 150G · S/N 15065171N52032Cessna 180J · S/N 18052452N53RDCessna 500 · S/N 500-0415N55214Piper PA-28-180 · S/N 28-7305334N5602VPiper PA-32R-300 · S/N 32R-7780345N5781BCessna 182 · S/N 33781N583JHCessna 208B · S/N 208B1001N599ASCessna 441 · S/N 441-0183N6524HCessna 172M · S/N 17265474N7483QCessna A185F · S/N 18503606N76509Cessna 140 · S/N 10941N779GWCirrus Design SR22T · S/N 9938N78RNNorth American/Victoria MNT LT AT-6A · S/N 77-4601N799GHHaley Myron G RV-7 · S/N 70094N8046GBeech F33A · S/N CE-1646N80DVTextron 700 · S/N 700-0070N86CYAmerican Champion 8KCAB · S/N 1073-2008N87KTBellanca 17-30A · S/N 87-30997N89JRRyan NAVION · S/N NAV-4-1381N9589YBeech 35-B33 · S/N CD-581
Back to Celina, TX