Bayamon, PR
Registered aircraft · 21
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'PR' AND g.registrant_city = 'BAYAMON' 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 = 'PR' AND g.registrant_city = 'BAYAMON' 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.
N106BCPiper PA-28-181 · S/N 2843582N132BCPiper PA-28-181 · S/N 2843583N135UPiper PA-44-180 · S/N 4496015N138BCPiper PA-28-181 · S/N 2843580N143JCQuad City CHALLENGER II · S/N JC001N157JNBaerga Francisco J QUICKSILVER GT500 · S/N 0424N183RLCessna 172M · S/N 17261654N311DJBell 407 · S/N 53440N324JRoome Joel R RANS S-12XL · S/N 06000920N345AHHeffelfinger Adam QCKSLVR SPORT 2S · S/N 0004N4126UPiper PA-28-181 · S/N 2843175N4131UPiper PA-28-181 · S/N 2843199N4165UPiper PA-28-181 · S/N 2843200N471JRCessna 172M · S/N 17260933N485BCPiper PA-44-180 · S/N 4496552N514KBeech J35 · S/N D-5566N61011Piper PA-28R-201 · S/N 2844139N6631YMuniz Terry F EIPPER GTS 400 · S/N 1349N868UPiper PA-28-181 · S/N 28020268N869BCPiper PA-28-181 · S/N 28020269N86CUEmbraer Executive EMB-505 · S/N 50500783
Back to Bayamon, PR