Precisionhawk USA Inc
Earlier aircraft under this name · 103
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 = 'PRECISIONHAWK USA INC' OR list_contains(d.other_registrant_names, 'PRECISIONHAWK USA 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 = 'PRECISIONHAWK USA INC' OR list_contains(d.other_registrant_names, 'PRECISIONHAWK USA 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.
N658PHPrecisionhawk HAWKEYE MKIII LANCAS · S/N LK3144413N1019Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-1N1044Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-2N1157Precisionhawk HAWKEYE MKIII LANCAS · S/N 001235-1N1180Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-1N1280Precisionhawk USA HAWKEYE MKIII LANCAS · S/N 001104-5N1377Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-2N1385Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-3N1503Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-4N1592Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-6N1623Precisionhawk HAWKEYE MKIII LANCAS · S/N 001255-7N1882Precisionhawk HAWKEYE MKIII LANCAS · S/N 001221-1N1897Precisionhawk HAWKEYE MKIII LANCAS · S/N 001221-2N2032Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-1N2034Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-2N2038Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-5N2039Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-6N2042Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-7N2044Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-8N2058Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-11N2074Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-14N2075Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-15N2080Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-16N2087Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-17N2093Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-19N2132Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-21N2138Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-22N2147Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-4N717DPPrecisionhawk HAWKEYE MKIII LANCAS · S/N 001255-5N1068Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-3N2126Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-20N1636Precisionhawk HAWKEYE MKIII LANCAS · S/N 001090-2N1842Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-048-201548-010-MSIN2036Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-3N2046Precisionhawk HAWKEYE MKIII LANCAS · S/N 001222-9N2049Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-10N2063Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-12N2070Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-13N2089Precisionhawk HAWKEYE MKIII LANCAS · S/N 01222-18N1302Precisionhawk HAWKEYE LANCASTER MK · S/N 001010-4N1375Precisionhawk HAWKEYE MKIII LANCAS · S/N 001104-6N1349Precisionhawk HAWKEYE MKIII LANCAS · S/N 001089-1N1353Precisionhawk HAWKEYE MKIII LANCAS · S/N 001089-2N1363Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-048-201529-028-MSIN1365Precisionhawk HAWKEYE MKIII LANCAS · S/N 001090-1N1190Precisionhawk HAWKEYE MKIII LANCAS · S/N 000715-2N1348Precisionhawk HAWKEYE MKIII LANCAS · S/N 001010-1N1722Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-0V6-201551-001-SERN1723Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-0V6-201551-002-SERN1730Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-0V6-201551-003-SER
Back to Precisionhawk USA Inc