Napa Valley Balloons Inc
Earlier aircraft under this name · 28
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'NAPA VALLEY BALLOONS INC' OR list_contains(d.other_registrant_names, 'NAPA VALLEY BALLOONS INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'NAPA VALLEY BALLOONS INC' OR list_contains(d.other_registrant_names, 'NAPA VALLEY BALLOONS INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N6953UCameron Balloons US A-250 · S/N 6856N4058MCameron Balloons US A-250 · S/N 6504N2145PFirefly Balloons FIREFLY 11 · S/N F11-2006N2196GFirefly Balloons GALAXY 11 · S/N GLX-11211N3751XBalloon Works FIREFLY 8-24 · S/N F8-028N4503NCameron Balloons US A-210 · S/N 6354N3202VBalloon Works FIRE FLY 10 · S/N F10-019N21963Firefly Balloons FIREFLY 10 · S/N F10-2006N5306NCameron Balloons US A-210 · S/N 6165N36914Balloon Works FIREFLY 8-24 · S/N F8-048N3288NBalloon Works FIRE FLY 10 · S/N F10-025N210NVThunder & Colt America AX10-210S2 · S/N 4795N31415Balloon Works FIRE FLY 10 · S/N F10-023N15078Firefly Balloons FIREFLY 11B · S/N F11B-2002N2552NBalloon Works FIREFLY 9B-15 · S/N F9B-003N2599NBalloon Works FIRE FLY 10 · S/N F10-004N9087NBalloon Works FIREFLY 9 · S/N F9-050N9091NBalloon Works FIREFLY 8-24 · S/N F8141N7405CBalloon Works FIREFLY 8-24 · S/N F8062N90850Balloon Works FIREFLY 9 · S/N F9036N4063KBalloon Works FIREFLY 7 · S/N 7995N4069GBalloon Works FIREFLY 8-24 · S/N 10044N3721NBalloon Works FIREFLY 8-24 · S/N F8066N9023ZBalloon Works FIREFLY 8 · S/N F8350N4053TBalloon Works FIREFLY 7 · S/N 10085N27046Balloon Works FIREFLY 8-24 · S/N 804N40514Balloon Works FIREFLY 7 · S/N 7953N2197HBalloon Works FIREFLY 7 · S/N 7793
Back to Napa Valley Balloons Inc