Friendswood, TX
Registered aircraft · 139
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 = 'FRIENDSWOOD' 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 = 'FRIENDSWOOD' 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.
N115TLCessna 560XL · S/N 560-5250N117TCCessna 310Q · S/N 310Q0786N12833Cessna 172M · S/N 17262299N129MRAerovodochody L-29 DELFIN · S/N 1234N1372BLuscombe 8F · S/N 5999N1594ZBeech P35 · S/N D-6886N172DLCessna 172M · S/N 17266166N189DKKnab Douglas J RV-8 · S/N 82734N19729Cessna 172L · S/N 17260704N1989MCessna 182P · S/N 18264518N2006EAeronca 7AC · S/N 7AC-5577N20223Cessna 177B · S/N 17702648N2037QBeech A36 · S/N E-1372N2121TGulfstream American AA-5B · S/N AA5B-1031N2268MCirrus Design SR22 · S/N 0642N2278Nanchang China CJ6A (YAK 18A) · S/N 2851274N23327Andrew P Broussard SLING2 · S/N 233N2411ZYakovlev YAK 52 · S/N 821911N241HCHughes Harry M VANS RV-8 · S/N 81966N24383Taylorcraft BC-65 · S/N 1719N2575ZBellanca 7ECA · S/N 1221-77N2698WMooney M20E · S/N 1011N270FACessna 182T · S/N 18281270N28171Piper J3C-65 · S/N 4631N2842WBeech V35B · S/N D-9491N298CJCessna 525B · S/N 525B0298N300FMEmbraer Executive EMB-505 · S/N 50500845N300MLKazee Homer GLASAIR III · S/N GA1113233N3047QCessna 182K · S/N 18258047N3048Cessna 337G · S/N 33701470N30PHBeech 58P · S/N TJ-5N3118RCessna 182L · S/N 18258518N311CSCessna 550 · S/N 550-0979N318SCCessna 172 · S/N 36261N3225KBeech A36 · S/N E-2975N32EEBeech A45 · S/N 53-4092N332CCJuliet Mike Holdings CCX-2000 · S/N CCX-2000-0198N3560PPiper PA-22-150 · S/N 22-3316N3621UCessna 182F · S/N 18255021N38506Piper J3F-65 · S/N 7075N385KCPiper PA46-500TP · S/N 4697385N3912GCessna 340A · S/N 340A0231N3KNBeech A36 · S/N E-1770N4029CStinson 108-3 · S/N 108-5029N4077RPiper PA-32-300 · S/N 32-40390N41014Piper J3C-65 · S/N 7648N42131Cessna 182L · S/N 18258867N42218Piper J3C-65 · S/N 14464N426ASCessna P206D · S/N P206-0590N427HHHawker Beechcraft G36 · S/N E-3770
Back to Friendswood, TX