Skip to content

Richardson Andrew P

Earlier aircraft under this name · 27

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 = 'RICHARDSON ANDREW P' OR list_contains(d.other_registrant_names, 'RICHARDSON ANDREW P') 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 = 'RICHARDSON ANDREW P' OR list_contains(d.other_registrant_names, 'RICHARDSON ANDREW P')
  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 = 'RICHARDSON ANDREW P' OR list_contains(d.other_registrant_names, 'RICHARDSON ANDREW P')
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.

N4016FAndrew Philip Richardson DBA A-60S · S/N 233Cancelled Sep 23, 2021 · Registration expired, pending cancellation · Albuquerque, NM N8418AAndrew Philip Richardson DBA A-B · S/N 260Cancelled Sep 23, 2021 · Registration expired, pending cancellation · Albuquerque, NM N842DAAndrew Philip Richardson DBA A-B · S/N 262Cancelled Sep 23, 2021 · Registration expired, pending cancellation · Albuquerque, NM N842EZAndrew Philip Richardson DBA A-B · S/N 259Cancelled Sep 23, 2021 · Registration expired, pending cancellation · Albuquerque, NM N40096Andrew Philip Richardson DBA A55S · S/N 230Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4017XAndrew Philip Richardson DBA LD S · S/N 237Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Albuquerque, NM N40205Andrew Philip Richardson DBA LD S · S/N 238Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Albuquerque, NM N842BRAndrew Philip Richardson DBA A-B · S/N 261Cancelled Sep 22, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4002JAndrew Philip Richardson DBA A55S · S/N 226Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4006QAndrew Philip Richardson DBA A-B · S/N 225Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4008XAndrew Philip Richardson DBA A-B · S/N 229Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4011ZAndrew Philip Richardson DBA A55S · S/N 231Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N40120Andrew Philip Richardson DBA A55S · S/N 232Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N40165Andrew Philip Richardson DBA LD S · S/N 236Cancelled Sep 21, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4017AAndrew Philip Richardson DBA A-60S · S/N 255Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Albuquerque, NM N40208Andrew Philip Richardson DBA A-60S · S/N 257Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Albuquerque, NM N4021ZAndrew Philip Richardson DBA A55S · S/N 258Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Albuquerque, NM N825DUAndrew Philip Richardson A-69 · S/N 243Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Albuquerque, NM N7950AAndrew Philip Richardson DBA A55 · S/N 220Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Albuquerque, NM N795QPAndrew Philip Richardson DBA A-60S · S/N 213Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Albuquerque, NM N795RRAndrew Philip Richardson DBA LD S · S/N 216Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Albuquerque, NM N795TAAndrew Philip Richardson DBA A55 · S/N 219Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Albuquerque, NM N672HAAndrew Philip Richardson DBA A55S · S/N 210Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Albuquerque, NM N643FRAndrew Philip Richardson DBA RV · S/N 208Cancelled May 6, 2019 · Registration expired, pending cancellation · Albuquerque, NM N525HRRichardson Andrew P RICHARDSON-PINATA105 · S/N 013Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Albuquerque, NM N525FRRichardson Andrew P RICHARDSON-SKULL 105 · S/N 010Cancelled Sep 21, 2017 · Exported to Mexico · Built 2015 · Albuquerque, NM N125RBCameron Balloons U S N 120 · S/N 6306Cancelled May 24, 2013 · Exported to Canada · Built 2002 · Bloomington, IN

Back to Richardson Andrew P