Pollard Aircraft Sales Inc
Earlier aircraft under this name · 23
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 = 'POLLARD AIRCRAFT SALES INC' OR list_contains(d.other_registrant_names, 'POLLARD AIRCRAFT SALES 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 = 'POLLARD AIRCRAFT SALES INC' OR list_contains(d.other_registrant_names, 'POLLARD AIRCRAFT SALES 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.
N550HGGates Learjet 55 · S/N 083N450PJGulfstream Aerospace G-IV · S/N 1388N777PNRaytheon B200 · S/N BB-1573N755JBBeech B200 · S/N BB1377N902SHHawker Beechcraft B200GT · S/N BY-69N11FTBeech C90 · S/N LJ-958N604FJCanadair CL-600-2B16 · S/N 5001N811MNRaytheon B200 · S/N BB-1598N822SBBeech B200 · S/N BB-981N485RBeech 200 · S/N BB-605N230BTDassault-Breguet FALCON 50 · S/N 62N258KTBritish Aerospace BAE 125 SERIES 800A · S/N 258007N27RDassault FALCON 2000 · S/N 05N604SHCanadair CL-600-1A11 · S/N 1008N133KTCessna 525 · S/N 525-0133N301HCBeech B200 · S/N BB-1219N78CTBeech 200 · S/N BB-761N364EABeech 200 · S/N BB-689N425APBeech 200 · S/N BB-682N57SCBeech B300 · S/N FL-34N280TTBeech 200 · S/N BB-280N315MSBeech 200 · S/N BB-404N498ACBeech 200 · S/N BB-287
Back to Pollard Aircraft Sales Inc