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.

N11209Cessna 150L · S/N 15075256Built 1973 · Pendragon Aviation LLCN113LRobert K Johnston S CUB · S/N 1Built 2021 · Johnston Robert KN131HHBucker Jungmann C.A.S.A. 1.131 · S/N E3B-396Built 1951 · Johnston Robert KN1333RGrumman American Avn. AA-5 · S/N AA5-0733Built 1975 · Norris Randy KN233RBeech V35B · S/N D9811Built 1975 · Plane Jane Aviation LLCN2531RPiper PA-28-180 · S/N 28-5642Maierhoffer Henry F JrN32754Piper J3L-65 · S/N 5589Built 1940 · Maierhoffer Henry F JrN3914ABeech E-55 · S/N TE-789Built 1970 · Plane Jane Aviation LLCN4325QCessna 172L · S/N 17260225Built 1971 · Beier Mark EN441SPCessna 182R · S/N 18268215Built 1982 · Pendragon Aviation LLCN4526HMooney M20J · S/N 24-0791Built 1979 · Johnston Robert KN46678Scottish Aviation Bulldog BULLDOG BH 120 · S/N 413Built 1975 · Morgan Dewey LN4801UCessna 210-5A(205A) · S/N 205-0501Built 1963 · Moore Douglas RN5323ECessna 172N · S/N 17271837Maierhoffer Henry FN552WTBeech D55 · S/N TE-486Built 1967 · Maierhoffer Henry F JrN556RBBeachler Randall SPORTSTER · S/N 71556Built 1988 · Mcbride Robert LN6188WHiggs Donald B FISHER HORIZON · S/N 56Built 1994 · Shuman Kevin FN626KWQuad City Ultralight Acft CHALLENGER II · S/N CWS 1515Built 1996 · Phillips Joshua DN6359KCessna 150M · S/N 15077662Built 1975 · Maierhoffer Henry F DBAN7116TCessna 172 · S/N 46716Maierhoffer Henry FN72ERCessna 172N · S/N 17269501Built 1977 · Maierhoffer Henry F JrN736GACessna R172K · S/N R1722505Built 1977 · Plane Jane Aviation LLCN786DCessna 140 · S/N 13786Built 1947 · Clifton Jerry EN80424Bucker Jungmann C.A.S.A. 1.131 · S/N E3B-447Built 1954 · Johnston Robert KN9116PPiper PA-24-260 · S/N 24-4594Built 1966 · Maierhoffer Henry F JrN92825Commonwealth 185 · S/N 1621Built 1946 · Phillips Joshua DN9757TPiper PA-38-112 · S/N 38-78A0189Built 1978 · Devevo Warren C Sr
Back to Sylvania, GA