Skip to content

Earlier aircraft under this name · 45

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'AIRCRANE INC' OR list_contains(d.other_registrant_names, 'AIRCRANE INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'AIRCRANE INC' OR list_contains(d.other_registrant_names, 'AIRCRANE 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 = 'AIRCRANE INC' OR list_contains(d.other_registrant_names, 'AIRCRANE 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.

N658ACSikorsky S-58ET · S/N 581537Cancelled Jan 6, 2022 · Exported to South Korea · Built 1962 · Winder, GA N50086Sikorsky CH37B · S/N 55-0641Cancelled Feb 17, 2017 · Registration expired, pending cancellation · West Chester, PA N7394Sikorsky CH37C · S/N 145875Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1959 · West Chester, PA N51905Sikorsky CH37B · S/N 57-1653Cancelled Dec 22, 2014 · Registration expired, pending cancellation · West Chester, PA N51914Sikorsky CH37B · S/N 58-0985Cancelled Dec 22, 2014 · Registration expired, pending cancellation · W Chester, PA N51916Sikorsky CH37B · S/N 58-0992Cancelled Dec 17, 2014 · Registration expired, pending cancellation · W Chester, PA N51891Sikorsky CH37B · S/N 54-1000Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51892Sikorsky CH37B · S/N 55-0616Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51894Sikorsky CH37B · S/N 55-0636Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51897Sikorsky CH37B · S/N 55-0647Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51899Sikorsky CH37B · S/N 55-0650Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51900Sikorsky CH37B · S/N 57-1646Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51901Sikorsky CH37B · S/N 57-1652Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51907Sikorsky CH37B · S/N 57-1657Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51908Sikorsky CH37B · S/N 57-1658Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51912Sikorsky CH37B · S/N 58-0983Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51915Sikorsky CH37B · S/N 58-0989Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51917Sikorsky CH37B · S/N 58-0984Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51918Sikorsky CH37B · S/N 58-0987Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51919Sikorsky CH37B · S/N 58-0990Cancelled Oct 27, 2014 · Registration expired, pending cancellation · West Chester, PA N51921Sikorsky CH37B · S/N 58-0991Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51923Sikorsky CH37B · S/N 58-0999Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51925Sikorsky CH37B · S/N 58-1000Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51926Sikorsky CH37B · S/N 58-1002Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51927Sikorsky CH37B · S/N 58-1004Cancelled Oct 27, 2014 · Registration expired, pending cancellation · W Chester, PA N51893Sikorsky CH37B · S/N 55-0623Cancelled Oct 1, 2014 · Registration expired, pending cancellation · West Chester, PA N51910Sikorsky CH37B · S/N 57-1659Cancelled Sep 10, 2014 · Registration expired, pending cancellation · West Chester, PA N14463Sikorsky CH37B · S/N 54-0999Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1957 · Birchrunville, PA N7384Sikorsky CH37C · S/N 145857Cancelled Oct 24, 2013 · Registration expired, pending cancellation · W Chester, PA N7382Sikorsky CH37C · S/N 141610Cancelled Sep 23, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N93017Sikorsky H-37 · S/N 145867Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1971 · West Chester, PA N7379Sikorsky CH37C · S/N 141605Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1970 · West Chester, PA N7380Sikorsky CH37C · S/N 141607Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7383Sikorsky CH37C · S/N 141614Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7385Sikorsky CH37C · S/N 145860Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7387Sikorsky CH37C · S/N 145861Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · West Chester, PA N7389Sikorsky CH37C · S/N 145869Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7390Sikorsky CH37C · S/N 145870Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7392Sikorsky CH37C · S/N 145873Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N7393Sikorsky CH37C · S/N 145872Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1959 · W Chester, PA N50174Sikorsky CH37B · S/N 54-0996Cancelled Mar 19, 2013 · Registration expired, pending cancellation · West Chester, PA N50226Sikorsky CH37B · S/N 54-0997Cancelled Mar 19, 2013 · Registration expired, pending cancellation · West Chester, PA N50119Sikorsky CH37B · S/N 54-0994Cancelled Aug 20, 2012 · Registration expired, pending cancellation · West Chester, PA N50253Sikorsky CH37B · S/N 54-0998Cancelled Aug 20, 2012 · Registration expired, pending cancellation · West Chester, PA N51896Sikorsky CH37B · S/N 550643Cancelled Dec 19, 1991 · Triennial form not returned · West Chester, PA

Back to Aircrane Inc