OpenAirDocs.org
Catlett, VA

Registered aircraft · 21

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 = 'CATLETT'
  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.

N11818Curtiss Wright JR CW1 · S/N 1225Ooi Lucy MN11KYPiper PA-30 · S/N 30-1181Built 1966 · Klad-Air LLCN262PDPitts Flying Club PITTS S-1S · S/N 01Built 1991 · Gritter Richard JN3068EAeronca 7AC · S/N 7AC-6657Whatley Allen WN321RJBellanca 8KCAB · S/N 323-77Built 1977 · Gritter Richard JN3870DCessna 182A · S/N 34570Built 1957 · Klad-Air LLCN4009BAeronca 7DC · S/N 7BCM-380Ooi Lucy MN5465DBeech H35 · S/N D-4976Built 1957 · Patten Sarah FN6296ECessna 172 · S/N 46396Built 1959 · Klad-Air LLCN6615HPiper J3C-65 · S/N 19813Patten Sarah FN7222HBeech A36 · S/N E-2179Built 1984 · 7222h LLCN72529Cessna 140 · S/N 9699Built 1946 · Kreit Kenneth SN740CMRauch Kenny F RV-4 · S/N 454Built 1998 · Silbersiepe ThomasN8200XCessna 172B · S/N 17248700Built 1961 · Klad-Air LLCN8345RPiper PA-28-140 · S/N 28-22219Built 1966 · Klad-Air LLCN83539Piper PA-18-150 · S/N 18-7709150Built 1977 · Silbersiepe Thomas EN8400XCessna 172C · S/N 17248900Built 1961 · Burlingame Craig DN910DGGreene Gerald D RR 111 · S/N 101Built 2010 · Whatley Allen WN9823BBellanca 14-19-2 · S/N 4075Ooi Lucy MN9833ACessna 195B · S/N 7512Built 1950 · Kreit Kenneth SamuelN98608Piper J-3 · S/N 18832Built 1946 · Gritter Richard J
Back to Catlett, VA