Sylvania, GA
Registered aircraft · 27
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 = 'GA' AND g.registrant_city = 'SYLVANIA' 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 = 'GA' AND g.registrant_city = 'SYLVANIA' 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.
N11209Cessna 150L · S/N 15075256N113LRobert K Johnston S CUB · S/N 1N131HHBucker Jungmann C.A.S.A. 1.131 · S/N E3B-396N1333RGrumman American Avn. AA-5 · S/N AA5-0733N233RBeech V35B · S/N D9811N2531RPiper PA-28-180 · S/N 28-5642N32754Piper J3L-65 · S/N 5589N3914ABeech E-55 · S/N TE-789N4325QCessna 172L · S/N 17260225N441SPCessna 182R · S/N 18268215N4526HMooney M20J · S/N 24-0791N46678Scottish Aviation Bulldog BULLDOG BH 120 · S/N 413N4801UCessna 210-5A(205A) · S/N 205-0501N5323ECessna 172N · S/N 17271837N552WTBeech D55 · S/N TE-486N556RBBeachler Randall SPORTSTER · S/N 71556N6188WHiggs Donald B FISHER HORIZON · S/N 56N626KWQuad City Ultralight Acft CHALLENGER II · S/N CWS 1515N6359KCessna 150M · S/N 15077662N7116TCessna 172 · S/N 46716N72ERCessna 172N · S/N 17269501N736GACessna R172K · S/N R1722505N786DCessna 140 · S/N 13786N80424Bucker Jungmann C.A.S.A. 1.131 · S/N E3B-447N9116PPiper PA-24-260 · S/N 24-4594N92825Commonwealth 185 · S/N 1621N9757TPiper PA-38-112 · S/N 38-78A0189
Back to Sylvania, GA