Piper Aircraft Inc
Registered aircraft · 219
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
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_name = 'PIPER AIRCRAFT INC' OR list_contains(g.other_registrant_names, 'PIPER AIRCRAFT INC') 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.
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_name = 'PIPER AIRCRAFT INC' OR list_contains(g.other_registrant_names, 'PIPER AIRCRAFT INC') ORDER BY g.n_number
Run 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.
N102DHPiper PA-44-180 · S/N 4496597N104DHPiper PA-28-181 · S/N 2881999N10594Taylor E-2 · S/N 12N115DXPiper PA-28-181 · S/N 28010102N115MAPiper PA-46-701TP · S/N 46020111N1160UPiper PA-28-181 · S/N 28020245N1230UPiper PA-28-181 · S/N 28020277N123FLPiper PA-44-180 · S/N 4496648N1250UPiper PA-28-181 · S/N 28020246N129JMPiper PA-46-701TP · S/N 46020129N1310UPiper PA-28-181 · S/N 28020247N131SAPiper PA-46-701TP · S/N 46020113N133WAPiper PA-46-701TP · S/N 46020133N1440UPiper PA-28-181 · S/N 28020248N145ARPiper PA-28-181 · S/N 28010047N152ARPiper PA-28-181 · S/N 28010048N154ARPiper PA-28-181 · S/N 28010049N155ARPiper PA-28-181 · S/N 28010050N157ARPiper PA-28-181 · S/N 28010053N162AVPiper PA-28-181 · S/N 28010078N163AVPiper PA-28-181 · S/N 28010061N164AVPiper PA-28-181 · S/N 28010060N164LHPiper PA-28-181 · S/N 28010063N165AVPiper PA-28-181 · S/N 28010059N165PPiper PA-28-181 · S/N 28020290N171PPiper PA-28-181 · S/N 28020291N175ARPiper PA-28-181 · S/N 28010054N175LHPiper PA-28-181 · S/N 28010064N176DXPiper PA-28-181 · S/N 28010103N176MAPiper PA46-500TP · S/N 4697729N177LHPiper PA-28-181 · S/N 28010065N178ARPiper PA-28-181 · S/N 28010055N179PPiper PA-28-181 · S/N 28020292N180EPPiper PA-44-180 · S/N 4496656N184CFPiper PA-28-181 · S/N 2843242N185LHPiper PA-28-181 · S/N 28010066N186PPiper PA-28-181 · S/N 28020293N187ARPiper PA-28-181 · S/N 28010087N188DXPiper PA-28-181 · S/N 28010104N18FYPiper PA-46-701TP · S/N 46020138N192PPiper PA-28-181 · S/N 28020294N1937BPiper PA 46-350P · S/N 4636858N193LHPiper PA-28-181 · S/N 28010067N19FYPiper PA-46-701TP · S/N 46020119N207ESPiper PA-28-181 · S/N 28020254N20PVPiper PA-44-180 · S/N 4496649N212DXPiper PA-28-181 · S/N 28010105N220STPiper PA-46-701TP · S/N 46020136N221BLPiper PA-28-181 · S/N 28010036N232DXPiper PA-28-181 · S/N 28010032
Back to Piper Aircraft Inc