Cavico Aircraft Sales Inc
Earlier aircraft under this name · 140
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 = 'CAVICO AIRCRAFT SALES INC' OR list_contains(d.other_registrant_names, 'CAVICO AIRCRAFT SALES 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 = 'CAVICO AIRCRAFT SALES INC' OR list_contains(d.other_registrant_names, 'CAVICO AIRCRAFT SALES 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.
N95903Cessna 182Q · S/N 18266674N734CYCessna TU206G · S/N U20604824N731XUCessna A188B · S/N 18803245TN3350ECessna 172N · S/N 17271513N9531GCessna U206F · S/N U20601731N3477YCessna U206G · S/N U20604249N4610UCessna U206G · S/N U20605001N4749UCessna U206G · S/N U20605080N5211XCessna TU206G · S/N U20605597N9384HCessna A185F · S/N 18503436N6767ECessna 172N · S/N 17272063N4603UCessna U206G · S/N U20604996N51022Cessna 172 · S/N 17274252N4716ZCessna U206G · S/N U20606007N60881Cessna A185F · S/N 18504068N61415Cessna A185F · S/N 185-04179N5247SCessna R182 · S/N R18201523N5311XCessna U206 · S/N U20605630N5189KCessna 172N · S/N 17274003N6434XCessna U206G · S/N U20605883N4878XCessna U206G · S/N U20605562N4921SCessna R182 · S/N R18201460N5311JCessna 404 · S/N 4040648N6091XCessna U206G · S/N U20605817N6432XCessna TU206G · S/N U20605881N5413CCessna 210N · S/N 21063745N27387Cessna 310R · S/N 310R1835N5124XCessna U206G · S/N U20605576N5258CCessna 310R · S/N 310R1529N5459XCessna U206 · S/N U20605773N6463XCessna U206G · S/N U20605901N5442XCessna TU206G · S/N U20605758N6170UCessna U206G · S/N U20605363N6407XCessna U206G · S/N U206-05871N4726ACessna A152 · S/N A1520882N6233XCessna U206G · S/N U206-05840N5389XCessna U206G · S/N U20605705N5166CCessna 210N · S/N 21063711N5132YCessna 210 · S/N 21064089N5178XCessna U206G · S/N U20605588N5452XCessna U206 · S/N U20605767N4724NCessna 182Q · S/N 18267313N5490XCessna 206 · S/N 20605804N73413Cessna 207A · S/N 20700587N6257XCessna U206G · S/N U206-05847N4888NCessna 182Q · S/N 18267440N6183XCessna TU206G · S/N U206-05834N4816NCessna 182Q · S/N 18267388N5316CCessna 210N · S/N 21063731N73352Cessna 207A · S/N 20700580
Back to Cavico Aircraft Sales Inc