OpenAirDocs.org
Petersburg, VA

Registered aircraft · 36

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

N12LABeech E-90 · S/N LW-49Central Virginia Aviation IncN132HSBeech E-90 · S/N LW-8Built 1972 · Central Virginia Aviation IncN15JHCessna 500 · S/N 500-0174Built 1974 · Central Virginia Aviation IncN167BBBeech C90 · S/N LJ-1054Built 1983 · Central Virginia Aviation IncN177HWCessna 177B · S/N 17701482Central Virginia Aviation IncN17NMBeech E-90 · S/N LW-237Built 1977 · Central Virginia Aviation IncN2052QCessna 177RG · S/N 177RG0452Built 1973 · Central Virginia Aviation IncN31062Piper PA46-500TP · S/N 4697208Built 2005 · Central Virginia Aviation IncN340NGCessna 340 · S/N 340-0042Central Virginia Aviation IncN34UPBeech A200 · S/N BC-006Built 1975 · Central Virginia Aviation IncN362JBPiper PA46-500TP · S/N 4697050Central Virginia Aviation IncN37DBBeech B-60 · S/N P-309Built 1974 · Central Virginia Aviation IncN400GKMitsubishi MU-300 · S/N A019 S.A.Built 1982 · Central Virginia Aviation IncN406CTCessna S550 · S/N S550-0038Built 1985 · Central Virginia Aviation IncN442JBCessna 500 · S/N 500-0117Built 1973 · Central Virginia Aviation IncN499RCCessna S550 · S/N S550-0090Central Virginia Aviation IncN510GPCessna 550 · S/N 550-0421Built 1982 · Central Virginia Aviation IncN51DACessna S550 · S/N S5500134Built 1987 · Central Virginia Aviation IncN549BRBeech C90 · S/N LJ-809Built 1978 · Central Virginia Aviation IncN56ABeech B200C · S/N BL-37Built 1981 · Central Virginia Aviation IncN600BFBeech 65-A90 · S/N LJ-193Built 1966 · Central Virginia Aviation IncN603PABeech B90 · S/N LJ-403Built 1968 · Central Virginia Aviation IncN6041UBeech 76 · S/N ME-175Built 1979 · Central Virginia Aviation IncN623BBBeech 65-A90 · S/N LJ-277Built 1967 · Airshares IncorpN704LFCessna 150M · S/N 15078690Built 1976 · Sable Douglas BN761KBeech B90 · S/N LJ-426Built 1968 · Central Virginia Aviation IncN7964KBeech 95-B55 (T42A) · S/N TC-685Central Virginia Aviation IncN7FLPiper PA-31T · S/N 31T-7820082Built 1978 · Central Virginia Aviation IncN80BTBeech E-90 · S/N LW-148Built 1975 · Central Virginia Aviation IncN85TBBeech C90 · S/N LJ-833Built 1979 · Central Virginia Aviation IncN878ZWyant Mp/Hawkins Jw/Hoover D RV-8 · S/N 80096Crawford Chris MN88UABeech 400 · S/N RJ-49Built 1988 · Central Virginia Aviation IncN899DBeech B90 · S/N LJ-386Built 1968 · Central Virginia Aviation IncN904DGBeech B200 · S/N BB-1176First renewal noticeBuilt 1983 · Central Virginia Aviation IncN911CXBeech C90 · S/N LJ-830First renewal noticeBuilt 1979 · Central Virginia Aviation IncN98TABeech B100 · S/N BE-56Built 1978 · Central Virginia Aviation Inc
Back to Petersburg, VA