- Manufacturer (registry)
- TALLMANTZ AVIATION CO.
- Model
- SOPWITH PUP
- Registry code
- 0562514
- Registered
- 0 aircraft
- Type
- Fixed wing single engine
- Engines
- 1 · Reciprocating
- Seats
- 1
- Weight class
- Up to 12,499 lb
- Cruise speed
- 85 mph
- Certification
- Not type certificated
Model codes come from the FAA registry’s reference file. ADs are matched to them by model name and maker.
On this page
Airworthiness directives that may apply · 0
ADs whose products match this airframe model. Each AD’s applicability may narrow it by serial number, part number or configuration.
No ADs matched this model
Registered aircraft · 0
No aircraft currently registered with this model
NTSB investigations
No NTSB investigations matched to aircraft with this modelMatched through the registry by N-number, so foreign aircraft and some older cases aren’t counted.
FAA incident reports
No reports matched to aircraft of this modelMatched through the registry by N-number, so foreign aircraft and some older reports aren’t counted.
Service difficulty reports
No reports name this modelGeneral aviation reporting is voluntary.
The same model under other registry codes
Amateur-built copies and renamed makers get their own codes.
Bloomquist Ronald SOPWITH PUP1 registered aircraftHam Howard S SOPWITH PUP1 registered aircraftA J D Engineering SOPWITH PUP1 registered aircraftFunkhouser SOPWITH PUP1 registered aircraftBurt Glenn B III SOPWITH PUP (L R T)1 registered aircraftJones Wesley Delbert SOPWITH PUP1 registered aircraftGolden Age Air Museum SOPWITH PUP1 registered aircraftBrian T Coughlin SOPWITH PUP1 registered aircraftVinelli Darren M SOPWITH PUP1 registered aircraftChernoch Walter W SOPWITH PUP1 registered aircraftPruitt-Tuberville SOPWITH PUP0 registered aircraftPruitt Ken SOPWITH PUP0 registered aircraft
Query with SQL
duckdb -csv -c "SELECT m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
WHERE m.match_key = 'SOPWITHPUP' AND m.code NOT IN ('0562514')
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 12"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.
SELECT m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
WHERE m.match_key = 'SOPWITHPUP' AND m.code NOT IN ('0562514')
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 12Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.