Cresson, TX
Registered aircraft · 72
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 = 'CRESSON' 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 = 'CRESSON' 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.
N102JKExtra Flugzeugproduktions EA 300/L · S/N 1250N1079VMooney M20J · S/N 24-3165N111WDBeech 95-B55 (T42A) · S/N TC-2126N113XBeech V35 · S/N D-8112N11SYBeech 95-B55 · S/N TC-1468N122KRRutkowski Kurt A GLASAIR SUPER II S · S/N 2360N136AABeech A36 · S/N E2229N13JXAmerican Legend AL3C-100 · S/N AL-1008N1632WBeech V35B · S/N D-9363N168WHClement James L WITTMAN TAILWIND · S/N JC11N1979KHudson Marc RV-10 · S/N 42427N19857Cessna 177B · S/N 17702608N200FVVolar CCK-1865 · S/N CCK-1865-1080N202DBCessna 421C · S/N 421C0488N210GPPeers Guy W RV-6 · S/N 60578N233DLHarvey Donald RV-9A · S/N 90281N2411LCessna 172H · S/N 17255611N28580Luscombe 8A · S/N 1409N2885UCessna 172D · S/N 17250485N3197SCessna 182G · S/N 18255697N321ELMooney M20R · S/N 29-0186N333BCCessna T210M · S/N 21061848N3739BBeech 58 · S/N TH-1198N37644Grumman American Avn. AA-5B · S/N AA5B-1294N389SBeech V35B · S/N D-9083N4072ZRobinson Helicopter R22 BETA · S/N 1884N407MBBabin Michael K JR TEXAS SPORT · S/N 1007N4131WPiper PA-32-300 · S/N 32-40197N416MKBeech 95-C55 · S/N TE-426N418LJClement James G CUB · S/N 346N42288Christen Industries A-1 · S/N 1329N4372LPiper PA-46-310P · S/N 46-8408087N4429NBoeing B75N1 · S/N 75-6635N44BTGlasflugel STANDARD LIBELLE · S/N 200N47557Piper PA-34-200T · S/N 34-7770414N47773Piper PA-28-181 · S/N 28-7890137N4791KRyan NAVION · S/N NAV-4-1791N49339Christen Industries PITTS S-1T · S/N 1047N5182RCessna 182S · S/N 18280707N5289KNavion NAVION B · S/N NAV-4-2189BN545JCCrabtree Jack L RV-4 · S/N 2634N5739SSchweizer SGS 2-33 · S/N 81N58949Cessna 182P · S/N 18262420N612RKCessna 172 · S/N 46603N615RTTasker Lary D KOLB MARK III EXTRA · S/N M3X04-2-00054N62898Piper PA-31-350 · S/N 317652157N63PZHoyt Patrick W CH 601 XL-B · S/N 001N63TZHoyt Patrick W CH 750 CRUZER · S/N 11637N654XMoonlina VANS RV-7 · S/N 70111N656EZMulvey Tim C LONG EZ · S/N 1841-L
Back to Cresson, TX