Reading, PA
Registered aircraft · 142
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 = 'READING' 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 = 'READING' 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.
N104QPiper J3C-65 · S/N 5335N109KGrumman TBM-3 · S/N 53638N111MMMooney M20L · S/N 26-0026N119ECFairchild M-62A · S/N T40-308N119QDPilatus PC-12/45 · S/N 119N120QDPilatus PC-12/45 · S/N 120N1224KSteven J Wyciechowski ZODIAC 601 XLB · S/N 6-5838N12RRRomano BUSHBY · S/N 1N1316VAeronca 7BCM · S/N 7BCM-446N1394Sikorsky HH-52A · S/N 1394N14742Kellett KD-1A · S/N 101N148RCCrocco Richard A RV-7A · S/N 71312N149QDPilatus PC-12/45 · S/N 149N15252Aeronca C-3 · S/N A-572N154SPMooney M20J · S/N 24-3274N15792Heath LNB-4 · S/N 1006N15JMidget Mustang MC-4 · S/N 55-1N15KBird A-T · S/N 1062N16470Sweet-Roger ARROW SPORT-S · S/N 001N1656FCessna 172H · S/N 17255051N168FNew Piper PA-28-181 · S/N 2843264N174HMMerkel Howard H J4B-2 · S/N HM-174N175MLFairchild C-119 · S/N 131677N18339Taylorcraft A · S/N 72N1841Flying Flea HM162 · S/N 1N1862HPiper PA-32R-300 · S/N 32R-7780196N19139Fairchild 24 G · S/N 2987N1RPGulfstream Aerospace GV-SP (G550) · S/N 5458N214NCamair 480 · S/N 1-058N22443Auster 5J1 · S/N 2034N229GBDouglas DC3C 1830-94 · S/N 26874N234Camair 480 · S/N 1-070N2373KCessna 172S · S/N 172S8074N243Camair 480 · S/N 1-077N24554North American-Banaire Entprs. SNJ-4 · S/N 88-12281N25546Rearwin 8135 · S/N 823N26475Meyers OTW · S/N 28N26MBoeing A75N1(PT17) · S/N 75-1925N28019Piper J3L-65 · S/N 4519N285SNMcfarland Lee SONEX · S/N 0723N288DXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000166N2946BPiper PA-28-236 · S/N 28-7911264N30031Zuck Daniel R PLANE-MOBILE · S/N 01N303JVVance James C KR 2 · S/N 001N3151FCessna 182J · S/N 18257251N32LBSilverlight APOLLO AG1 · S/N USA201114N333JAAbell John B VANS RV-6A · S/N 24339N333RAS.O.C.A.T.A. RALLYE 150 ST · S/N 3094N338QDPilatus PC-12/45 · S/N 338N338VADolan Andrew M DONS EAGLE · S/N 01
Back to Reading, PA