Aviation Services International Inc
Earlier aircraft under this name · 329
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 = 'AVIATION SERVICES INTERNATIONAL INC' OR list_contains(d.other_registrant_names, 'AVIATION SERVICES INTERNATIONAL 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 = 'AVIATION SERVICES INTERNATIONAL INC' OR list_contains(d.other_registrant_names, 'AVIATION SERVICES INTERNATIONAL 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.
N4371JPiper PA-34-220T · S/N 34-8433083N4552WPiper PA-30 · S/N 30-1879N4333ZPiper PA-28-181 · S/N 28-8490034N8236BPiper PA-44-180T · S/N 44-8207020N3049APiper PA-28-181 · S/N 287990115N8210JPiper PA-34-220T · S/N 34-8233149N4533TGulfstream American AA-5B · S/N AA5B1187N4531LGulfstream American AA-5B · S/N AA5B-1160N8453HPiper PA-28-181 · S/N 288290048N4533NGulfstream American AA-5B · S/N AA5B1184N4532VGulfstream American AA-5B · S/N AA5B1177N83666Piper PA-28-181 · S/N 288190208N4533LGulfstream American AA-5B · S/N AA5B1182N83691Piper PA-28RT-201 · S/N 28R8118063N8372BPiper PA-34-220T · S/N 348133066N83745Piper PA-34-220T · S/N 348133073N83684Piper PA-32-301 · S/N 32-8106056N8360APiper PA-32R-301T · S/N 32R8129056N8317SPiper PA-44-180 · S/N 44-8195013N8333APiper PA-28RT-201T · S/N 28R-8131076N83353Piper PA-28-181 · S/N 28-8190165N4555YGulfstream American AA-5B · S/N AA5B-1218N8257VPiper PA-28-181 · S/N 28-8190020N8271ZPiper PA-32R-301 · S/N 32R-8013134N26836Gulfstream American AA-5A · S/N AA5A-0754N26906Gulfstream American AA-5A · S/N AA5A0803N8257EPiper PA-28-181 · S/N 28-8190017N8500HGulfstream American GA-7 · S/N GA70107N82401Piper PA-28-161 · S/N 28-8016369N26879Gulfstream American AA-5A · S/N AA5A-0781N26877Gulfstream American AA-5A · S/N AA5A-0780N26905Gulfstream American AA-5A · S/N AA5A-0801N82469Piper PA-28-161 · S/N 28-8016372N3752EGulfstream American AA-5B · S/N AA5B-1104N37519Gulfstream American AA-5B · S/N AA5B-1179N26750Gulfstream American AA-5A · S/N AA5A-0692N82377Piper PA-28R-201T · S/N 28R-8031133N26795Gulfstream American AA-5A · S/N AA5A-0730N3756LGulfstream American AA-5B · S/N AA5B-0996N26857Gulfstream American AA-5A · S/N AA5A-0771N4532LGulfstream American AA-5B · S/N AA5B1172N26823Gulfstream American AA-5A · S/N AA5A-0743N82162Piper PA-28-161 · S/N 28-8016331N81963Piper PA-28-181 · S/N 288090290N8188SPiper PA-32R-301 · S/N 32R8013089N81969Piper PA-28-181 · S/N 288090291N82173Piper PA-28-181 · S/N 28-8090314N8216TPiper PA-28-181 · S/N 28-8090311N2555ZPiper PA-23-250 (6PCLM) · S/N 27-8054042N8146RPiper PA-28-181 · S/N 288090221
Back to Aviation Services International Inc