Angel Aviation Inc
Registered aircraft · 24
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'ANGEL AVIATION INC' OR list_contains(g.other_registrant_names, 'ANGEL AVIATION INC') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'ANGEL AVIATION INC' OR list_contains(g.other_registrant_names, 'ANGEL AVIATION INC') ORDER BY g.n_number
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.
N24143Cessna 175 · S/N 55436N3552ECessna 172N · S/N 17271584N35727Piper PA-34-200T · S/N 348070084N3974XPiper PA-34-200T · S/N 34-7670011N4226HPiper PA-14 · S/N 14-29N4265HPiper PA-14 · S/N 14-69N47536Piper PA-34-200T · S/N 34-7770412N48787Cessna 152 · S/N 15280967N492WPCessna 172N · S/N 17272684N49827Cessna 152 · S/N 15281344N51883Cessna 172P · S/N 17274371N51885Cessna 172P · S/N 17274372N52436Cessna 172P · S/N 17274520N64056Cessna 172P · S/N 17275512N65065Cessna 172P · S/N 17275681N65698Cessna 172P · S/N 17275822N757GQCessna 152 · S/N 15279732N757MSCessna 152 · S/N 15279854N8174RPiper PA-34-200T · S/N 34-8070157N8502VPiper PA-34-200 · S/N 34-7350252N9002HCessna 172M · S/N 17265892N97705Cessna 172P · S/N 17276223N97811Cessna 172P · S/N 17276232N9885QCessna 172M · S/N 17265829
Back to Angel Aviation Inc