Skip to content

Zipline International Inc

Registered aircraft · 3,145

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

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 = 'ZIPLINE INTERNATIONAL INC' OR list_contains(g.other_registrant_names, 'ZIPLINE INTERNATIONAL INC') ORDER BY g.n_number

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 = 'ZIPLINE INTERNATIONAL INC' OR list_contains(g.other_registrant_names, 'ZIPLINE INTERNATIONAL 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 = 'ZIPLINE INTERNATIONAL INC' OR list_contains(g.other_registrant_names, 'ZIPLINE INTERNATIONAL 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.

N102CBZipline International P2 ZIP · S/N P2-ZIP-00155S San Fran, CA N102DCZipline International P2 ZIP · S/N 18736P22773S San Fran, CA N106DMZipline International P2 ZIP · S/N 18738P2224S San Fran, CA N106DPZipline International P2 ZIP · S/N 18736P23141S San Fran, CA N106ZLZipline International P2 ZIP · S/N 18736P22000S San Fran, CA N106ZPZipline International P2 ZIP · S/N 18735P2454S San Fran, CA N111ZPZipline International P2 ZIP · S/N 18735P2496S San Fran, CA N112DCZipline International P2 ZIP · S/N 18736P22757S San Fran, CA N115ZLZipline International P2 ZIP · S/N 18736P23121S San Fran, CA N125CBZipline International P2 ZIP · S/N P2-ZIP-00133San Francisco, CA N125ZLZipline International P2 ZIP · S/N 18736P23122S San Fran, CA N126CBZipline International P2 ZIP · S/N P2-ZIP-00135S San Fran, CA N128DCZipline International P2 ZIP · S/N 18738P2221S San Fran, CA N137ZLZipline International P2 ZIP · S/N 18736P23123S San Fran, CA N145DCZipline International P2 ZIP · S/N 18736P22465S San Fran, CA N151DCZipline International P2 ZIP · S/N 18736P22758S San Fran, CA N151ZLZipline International P2 ZIP · S/N 18736P23124S San Fran, CA N152ZLZipline International P2 ZIP · S/N 18736P23125S San Fran, CA N153ZLZipline International P2 ZIP · S/N 18736P23126S San Fran, CA N155ZLZipline International P2 ZIP · S/N 18736P23127S San Fran, CA N158ACZipline International P2 ZIP · S/N 18736P22761S San Fran, CA N159EVZipline International P2 ZIP PRE-EV · S/N P2-PREEV-ZIP-0013S San Fran, CA N159ZLZipline International P2 ZIP · S/N 18736P23128S San Fran, CA N159ZPZipline International P2 ZIP · S/N 18735P2455S San Fran, CA N161DPZipline International P2 ZIP · S/N 18736P23142S San Fran, CA N163EEZipline International P2 ZIP · S/N 18735P2385S San Fran, CA N167ZPZipline International P2 ZIP · S/N 18735P2462S San Fran, CA N170DCZipline International P2 ZIP PRE-EV · S/N P2-PREEV-ZIP-0014S San Fran, CA N174JFZipline International P2 ZIP · S/N 18736P21101S San Fran, CA N175DPZipline International P2 ZIP · S/N 18736P23143S San Fran, CA N178DPZipline International P2 ZIP · S/N 18736P23144S San Fran, CA N181EEZipline International P2 ZIP · S/N 18735P2377S San Fran, CA N183DPZipline International P2 ZIP · S/N 18736P23145S San Fran, CA N187DPZipline International P2 ZIP · S/N 18736P23146S San Fran, CA N187JFZipline International P2 ZIP · S/N 18736P21102S San Fran, CA N188DPZipline International P2 ZIP · S/N 18736P23147S San Fran, CA N192DPZipline International P2 ZIP · S/N 18736P23148S San Fran, CA N193ZPZipline International P2 ZIP · S/N 18735P2463S San Fran, CA N194JFZipline International P2 ZIP · S/N 18736P21103S San Fran, CA N195EEZipline International P2 ZIP · S/N 18735P2386S San Fran, CA N195PPZipline International P2 ZIP · S/N P2-ZIP-00168S San Fran, CA N196DCZipline International P2 ZIP PRE-EV · S/N P2-PREEV-ZIP-0031S San Fran, CA N197EEZipline International P2 ZIP · S/N 18735P2378S San Fran, CA N200EVZipline International P2 ZIP PRE-EV · S/N 18737P225S San Fran, CA N202DDZipline International P2 ZIP · S/N P2-ZIP-00158S San Fran, CA N203ALZipline International P2 ZIP · S/N 18736P21501S San Fran, CA N203DPZipline International P2 ZIP · S/N 18736P23149S San Fran, CA N204ALZipline International P2 ZIP · S/N 18736P21502S San Fran, CA N207JFZipline International P2 ZIP · S/N 18736P21104S San Fran, CA N208JFZipline International P2 ZIP · S/N 18736P21105S San Fran, CA

Back to Zipline International Inc