OpenAirDocs.org
Conshohocken, PA

Registered aircraft · 41

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 = 'PA' AND g.registrant_city = 'CONSHOHOCKEN'
  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.

N352FTGulfstream Aerospace G-IV · S/N 1420Built 2000 · 352 CorpN372EXDassault FALCON 2000EX · S/N 12Built 2003 · Real Estate Services International LLCN560RWCessna 560 · S/N 5600196First renewal noticeBuilt 1992 · Rbw Enterprises IncN625REPae ISR RESOLUTE EAGLE · S/N 17-004XAmerican Aerospace Technologies IncN627REPae ISR RESOLUTE EAGLE · S/N 19-007American Aerospace Technologies IncN628REPae ISR RESOLUTE EAGLE · S/N 17-007XAmerican Aerospace Technologies IncN630REPae ISR RESOLUTE EAGLE · S/N 17-008XAmerican Aerospace Technologies IncN631REPae ISR RESOLUTE EAGLE · S/N 19-008American Aerospace Technologies IncN632REPae ISR RESOLUTE EAGLE · S/N 17-010XAmerican Aerospace Technologies IncN634REPae ISR RESOLUTE EAGLE · S/N 17-012XAmerican Aerospace Technologies IncN636REPae ISR RESOLUTE EAGLE · S/N 17-014XAmerican Aerospace Technologies IncN638REPae ISR RESOLUTE EAGLE · S/N 17-016XAmerican Aerospace Technologies IncN639REPae ISR RESOLUTE EAGLE · S/N 19-011American Aerospace Technologies IncN641REPae ISR RESOLUTE EAGLE · S/N 19-001Built 2019 · American Aerospace Technologies IncN642REPae ISR RESOLUTE EAGLE · S/N 19-002Built 2019 · American Aerospace Technologies IncN643REPae ISR RESOLUTE EAGLE · S/N 19-003American Aerospace Technologies IncN644REPae ISR RESOLUTE EAGLE · S/N 19-004American Aerospace Technologies IncN645REPae ISR RESOLUTE EAGLE · S/N 19-005Built 2019 · American Aerospace Technologies IncN646AUAmerican Aerospace Tech AIRANGER · S/N 23-0006Built 2023 · American Aerospace Technologies IncN647AUAmerican Aerospace Tech AIRANGER · S/N 23-0007American Aerospace Technologies IncN647REPae ISR RESOLUTE EAGLE · S/N 17-005XAmerican Aerospace Technologies IncN648AUAmerican Aerospace Tech AIRANGER · S/N 23-0008Built 2023 · American Aerospace Technologies IncN648REPae ISR RESOLUTE EAGLE · S/N 17-002XAmerican Aerospace Technologies IncN649AUAmerican Aerospace Tech AIRANGER · S/N 23-0009American Aerospace Technologies IncN650AUAmerican Aerospace Tech AIRANGER · S/N 23-0010American Aerospace Technologies IncN652REPae ISR RESOLUTE EAGLE · S/N 17-015XAmerican Aerospace Technologies IncN653REPae ISR RESOLUTE EAGLE · S/N 19-016American Aerospace Technologies IncN654REPae ISR RESOLUTE EAGLE · S/N 19-017American Aerospace Technologies IncN655REPae ISR RESOLUTE EAGLE · S/N 19-018American Aerospace Technologies IncN657REPae ISR RESOLUTE EAGLE · S/N 19-019American Aerospace Technologies IncN658REPae ISR RESOLUTE EAGLE · S/N 19-020American Aerospace Technologies IncN659REPae ISR RESOLUTE EAGLE · S/N 19-021American Aerospace Technologies IncN660REPae ISR RESOLUTE EAGLE · S/N 19-022American Aerospace Technologies IncN661REPae ISR RESOLUTE EAGLE · S/N 19-023American Aerospace Technologies IncN662REPae ISR RESOLUTE EAGLE · S/N 19-024American Aerospace Technologies IncN663REPae ISR RESOLUTE EAGLE · S/N 19-025American Aerospace Technologies IncN664REPae ISR RESOLUTE EAGLE · S/N 19-026American Aerospace Technologies IncN665REPae ISR RESOLUTE EAGLE · S/N 19-027American Aerospace Technologies IncN666REPae ISR RESOLUTE EAGLE · S/N 19-028American Aerospace Technologies IncN668REPae ISR RESOLUTE EAGLE · S/N 19-030American Aerospace Technologies IncN669REPae ISR RESOLUTE EAGLE · S/N 19-031American Aerospace Technologies Inc
Back to Conshohocken, PA