Phoenix East Aviation LLC
Registered aircraft · 48
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 = 'PHOENIX EAST AVIATION LLC' OR list_contains(g.other_registrant_names, 'PHOENIX EAST AVIATION LLC') 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 = 'PHOENIX EAST AVIATION LLC' OR list_contains(g.other_registrant_names, 'PHOENIX EAST AVIATION LLC') 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.
N1087CCessna 172S · S/N 172S10268N1239TPiper PA-34-200 · S/N 34-7250270N1309GCessna 172S · S/N 172S10342N147HACessna 172S · S/N 172S10219N1533EPiper PA-34-200 · S/N 34-7350050N15839Piper PA-34-200 · S/N 34-7350100N17304Cessna 172S · S/N 172S10643N2221RCessna 172R · S/N 17280681N227BHCessna 172S · S/N 172S10662N22904Cessna 172S · S/N 172S9961N2407NCessna 172S · S/N 172S10550N260PECessna 172S · S/N 172S11001N275PECessna 172S · S/N 172S10515N282PECessna 172S · S/N 172S10750N290PETextron 172S · S/N 172S12864N291PETextron 172S · S/N 172S12865N292PETextron 172S · S/N 172S12866N293PETextron 172S · S/N 172S12869N294PETextron 172S · S/N 172S12870N295PETextron 172S · S/N 172S12871N296PECessna 172S · S/N 172S10211N297PECessna 172S · S/N 172S10338N298PECessna 172S · S/N 172S10147N444SAPiper PA-34-200 · S/N 34-7250183N455LPiper PA-34-200 · S/N 34-7450172N4567TPiper PA-34-200 · S/N 34-7250136N4907TPiper PA-34-200 · S/N 34-7250184N5037TPiper PA-34-200 · S/N 34-7250205N509NDCessna 172S · S/N 172S10950N521NDCessna 172S · S/N 172S10975N524NDCessna 172S · S/N 172S10979N527NDCessna 172S · S/N 172S10818N529NDCessna 172S · S/N 172S10981N536NDCessna 172S · S/N 172S10932N550NDCessna 172S · S/N 172S10992N558NDCessna 172S · S/N 172S10993N565ADCessna 172S · S/N 172S9991N6065MCessna 172S · S/N 172S10251N61237Cessna 172S · S/N 172S10674N66068Cessna 172S · S/N 172S9790N707PEPiper PA-34-200 · S/N 34-7250149N727PEPiper PA-34-200 · S/N 34-7250110N737PEPiper PA-34-200 · S/N 34-7350171N747PEPiper PA-34-200 · S/N 34-7450112N780JACessna 172S · S/N 172S10476N781JACessna 172S · S/N 172S10329N787PEPiper PA-34-200 · S/N 34-7350033N974DBCessna 172S · S/N 172S10661
Back to Phoenix East Aviation LLC