Pilotmec Aircraft Services Inc
Earlier aircraft under this name · 34
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 = 'PILOTMEC AIRCRAFT SERVICES INC' OR list_contains(d.other_registrant_names, 'PILOTMEC AIRCRAFT SERVICES 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 = 'PILOTMEC AIRCRAFT SERVICES INC' OR list_contains(d.other_registrant_names, 'PILOTMEC AIRCRAFT SERVICES 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.
N181PAGates Learjet 25D · S/N 346N4174SBeech 58 · S/N TH-621N76339Cessna 140 · S/N 10756N89804Cessna 140 · S/N 8853N3024LRobinson Helicopter R44 II · S/N 11615N3259GCessna U206G · S/N U206-06039N199LKCessna 172RG · S/N 172RG0701N758WMCessna R172K · S/N R1723418N65539Cessna 152 · S/N 15281604N5355VCessna T210L · S/N 21060919N269ADNew Piper PA46-350P · S/N 4636387N4823GCessna 172N · S/N 17273371N9358DCessna 172RG · S/N 172RG1133N534JCCirrus Design SR22 · S/N 0243N54BYAmerican Champion 7GCBC · S/N 1404-2005N757EACessna 152 · S/N 15279670N491LUCessna U206G · S/N U20604778N127SBRaytheon 58 · S/N TH-2086N2872SPiper PA-34-200T · S/N 34-7970315N8378FRaytheon A36 · S/N E-3574N3409LCessna U206B · S/N U206-0709N736SCCessna R172K · S/N R1722744N239CCPiper PA 46-350P · S/N 4636315N9012QBeech 58 · S/N TH62N772MBRaytheon G36 · S/N E-3722N8456EPiper PA-34-220T · S/N 34-8233010N8302BRaytheon A36 · S/N E-3511N8301DRaytheon A36 · S/N E3509N4870VCessna 172RG · S/N 172RG0405N1068YBeech A36 · S/N E-2998N616CRPiper PA32-301FT · S/N 3232008N1660XCessna 210L · S/N 21060695N8413BPiper PA-34-220T · S/N 34-8133159N4189ZPiper PA-34-220T · S/N 3449189
Back to Pilotmec Aircraft Services Inc