OpenAirDocs.org
Springfield, VA

Registered aircraft · 33

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 = 'VA' AND g.registrant_city = 'SPRINGFIELD'
  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.

N101NMPiper PA-32RT-300 · S/N 32R7985099Harris Group LLCN10568Cessna 150L · S/N 15074914Built 1973 · Buchner Mark LN140EBBurns Richard E VANS RV-14A · S/N 140214Burns Richard EN170LCessna 170B · S/N 26252Built 1954 · Schaible Peter JN1920WBeech B19 · S/N MB-579Built 1973 · Wilfert FrederickN2056DBeech C35 · S/N D-3399Built 1953 · Bickert Marshal AN2885RPiper PA-28R-200 · S/N 28R-35318Built 1969 · Arrow Flight LLCN304BSHPH GLASFLUGEL 304CZ · S/N 27Built 2000 · Bates Matthew TN32293Piper PA-28-180 · S/N 28-7505046Built 1974 · Stone James BN401JGGulfstream Aerospace GVII-G500 · S/N 72137Built 2024 · Jvg Holdings CorpN4088NCessna 140 · S/N 13546Built 1947 · 4088n LLCN4150GCessna 340A · S/N 340A0320Web LLCN4170LPiper PA-28-181 · S/N 28-43387Built 2000 · Osborn Allan R TrusteeN42ATAerotrike SAFARI HKS · S/N BILL-JACOBSONBuilt 1998 · Beste Stephen HN44579Piper PA-28-151 · S/N 28-7415672Built 1974 · Schaible Peter JN46135Cessna 152 · S/N 15283004Built 1978 · Mc Masters James IN507ABAmodeo James F JR CHALLENGER · S/N CH2 1097 1672Sale reportedN58156Mooney M20J · S/N 24-1582Built 1986 · Kim SeukN5920DPiper PA-22-150 · S/N 22-4582Built 1956 · Bates Matthew TN6472JPiper PA-28-180 · S/N 28-4898Built 1968 · FAA Flying Club IncN6712JPiper PA-28-140 · S/N 28-24410F & F Flying Service IncN681BBeech A35 · S/N D-1684Built 1948 · Clatterbuck Guy E JrN716GWWard Gary P MX2 · S/N 4Built 2006 · Taylor David ClarkN729KXCirrus Design SR22T · S/N 0527Built 2013 · Shrago Daniel AN75382Piper PA-28-151 · S/N 28-7615296Built 1976 · FAA Flying Club IncN7597RPiper PA-28-140 · S/N 28-22165Built 1966 · Garces Carlos AN7709RBeech 36 · S/N E-102Built 1968 · Bonanza Angels LLCN7891UCessna 150M · S/N 15077857Built 1976 · Cessna 150 152 Fly In FoundationN8462WPiper PA-28-180 · S/N 28-2924Built 1965 · Lazear William RandolphN861PSPiper PA-46-701TP · S/N 46020041Built 2024 · P And P Services LLCN8913WPiper PA-28-235 · S/N 28-10482Mra Aviation IncN9397WPiper PA-28-235 · S/N 28-11094Built 1968 · FAA Flying Club IncN9516MMooney M20F · S/N 670093Built 1966 · Burrell John Eric
Back to Springfield, VA