International Aircraft Services LLC
Earlier aircraft under this name · 64
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 = 'INTERNATIONAL AIRCRAFT SERVICES LLC' OR list_contains(d.other_registrant_names, 'INTERNATIONAL AIRCRAFT SERVICES LLC') 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 = 'INTERNATIONAL AIRCRAFT SERVICES LLC' OR list_contains(d.other_registrant_names, 'INTERNATIONAL AIRCRAFT SERVICES LLC') 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.
N6113TCessna 150E · S/N 15060813N73FCPiper PA-28R-201T · S/N 28R-7703358N759SWCessna 182Q · S/N 18266232N3570MPiper PA-34-200T · S/N 34-7870117N4770NCessna 182Q · S/N 18267353N2353PCessna 182S · S/N 18280421N95620Cessna 182Q · S/N 18266580N735WJCessna 182Q · S/N 18265740N8235VPiper PA-28RT-201T · S/N 28R-8031128N367Cowdrey Joel Haden JR GLASAIR II SH/2R · S/N 2142N125CZCessna U206F · S/N U20602961N4684KCessna R172K · S/N R1722011N232JCessna 182T · S/N 18281065N815RVHinkley Curtis R VANS RV-8 · S/N 80015N2928QPiper PA-28R-201T · S/N 28R-7703080N4920WRockwell International 114 · S/N 14244N611RRPiper PA-31T1 · S/N 31T-8004006N9272QPiper PA-28-181 · S/N 2843038N90WMBeech F33A · S/N CE-1439N24222Cessna 152 · S/N 15280157N52548Cessna 182P · S/N 18262670N557CPiper PA-34-220T · S/N 3449247N90DBPiper PA-34-200T · S/N 34-7870448N6273KCessna 150M · S/N 15077620N128CCPiper PA-28RT-201T · S/N 28R-8031046N114URockwell International 114 · S/N 14028N32676Piper PA-34-200T · S/N 34-7570043N320ADDavis Ronald James VANS RV-7 · S/N 71824N5080UCessna 206 · S/N 206-0080N91594Cessna T207A · S/N 20700706N220SARaytheon 58 · S/N TH-2003N60665Cirrus Design SR22 · S/N 1275N60182Cirrus Design SR20 · S/N 1490N61036Cirrus Design SR22 · S/N 1305N398CDCirrus Design SR22 · S/N 1274N54125Cirrus Design SR22 · S/N 1203N187CDCirrus Design SR22 · S/N 0927N692CDCirrus Design SR22 · S/N 1017N193CDCirrus Design SR22 · S/N 0928N628CDCirrus Design SR22 · S/N 0912N5004RCirrus Design SR22 · S/N 0851N51239Cirrus Design SR22 · S/N 0849N53423Cirrus Design SR22 · S/N 0828N803KCCirrus Design SR22 · S/N 0807N5361XCirrus Design SR20 · S/N 1409N81239Cirrus Design SR20 · S/N 1392N80904Cirrus Design SR22 · S/N 0780N81246Cirrus Design SR20 · S/N 1389N8157HCirrus Design SR20 · S/N 1376N8154LCirrus Design SR20 · S/N 1374
Back to International Aircraft Services LLC