Quakertown, PA
Registered aircraft · 32
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 = 'PA' AND g.registrant_city = 'QUAKERTOWN' 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 = 'PA' AND g.registrant_city = 'QUAKERTOWN' 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.
N1170YCessna 150B · S/N 15059570N1UKPiper PA-28-181 · S/N 28-7790564N201PKMooney M20J · S/N 24-0278N2047PBeech A36 · S/N E-1401N215SBeech D35 · S/N D-3499N2336WBeech A23A · S/N M-933N2515VCessna 170 · S/N 18018N3447BBeech D35 · S/N D-3685N36MJCessna A185F · S/N 18504104N38356Piper PA-28-181 · S/N 28-7790543N4057GBalloon Works FIREFLY 7 · S/N 10115N428RWBalony Kubicek Spol Sro BB30D · S/N 1062N43721Piper PA-28-180 · S/N 28-7405215N44247Taylorcraft BC12-D · S/N 10047First renewal noticeN47FMMooney M20J · S/N 24-3424N5178WPiper PA-28-160 · S/N 28-213N51DCBRM Aero S R O BRISTELL LSA · S/N 378/2018N5402SPiper PA-28-180 · S/N 28-7105139N555CDCessna A185F · S/N 18502656First renewal noticeN5764JMooney M20J · S/N 24-1478N57JAPiper PA-28-181 · S/N 28-7990270N626CPPiper PA-28-181 · S/N 28-7990396N628DWBalony Kubicek Spol Sro BB30Z · S/N 1303N6627XBeech 76 · S/N ME-215N736YDCessna R172K · S/N R1722886N737AWCessna 172N · S/N 17269277N8318QPiper PA-28-181 · S/N 28-8190130N8422RPiper PA-28-140 · S/N 28-22299N8688YPiper PA-30 · S/N 30-1834N9290JPiper PA-28-180 · S/N 28-3375N95427Piper PA-28-140 · S/N 28-25945N9631LGrumman American Avn. AA-1B · S/N AA1B-0131
Back to Quakertown, PA