Registered aircraft · 23

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

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 = 'PONDEROSA AVIATION LLC' OR list_contains(g.other_registrant_names, 'PONDEROSA AVIATION LLC') ORDER BY g.n_number

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 = 'PONDEROSA AVIATION LLC' OR list_contains(g.other_registrant_names, 'PONDEROSA 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 = 'PONDEROSA AVIATION LLC' OR list_contains(g.other_registrant_names, 'PONDEROSA 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.

N127HJRockwell International 690B · S/N 11467Built 1978 · Safford, AZ N17DLAero Commander 500 S · S/N 1866-42Built 1969 · Safford, AZ N197GBRockwell International 690A · S/N 11282Built 1975 · Safford, AZ N210HDAero Commander 500 S · S/N 1841-33Built 1969 · Safford, AZ N32WSRockwell International 690A · S/N 11339Built 1976 · Safford, AZ N3UVAero Commander 500 S · S/N 3146Built 1973 · Safford, AZ N411KCBeech B200 · S/N BB-901Built 1981 · Safford, AZ N434CFCessna 525A · S/N 525A0434Built 2009 · Safford, AZ N44NCRockwell International 690B · S/N 11387Built 1977 · Safford, AZ N45AZRockwell International 690B · S/N 11383Built 1977 · Safford, AZ N4QSAero Commander 500 S · S/N 1755-1Built 1968 · Safford, AZ N585RBBeech 200 · S/N BB-528Built 1979 · Safford, AZ N67BECessna 550 · S/N 550-0619Built 1989 · Safford, AZ N690ARAero Commander 690A · S/N 11155Built 1974 · Safford, AZ N690CPRockwell International 690B · S/N 11451Built 1978 · Safford, AZ N690FDRockwell International 690B · S/N 11393Built 1977 · Safford, AZ N690HBAero Commander 690A · S/N 11205Built 1974 · Safford, AZ N701EXCessna 525A · S/N 525A-0375Built 2007 · San Francisco, CA N711CMBeech 95-55 · S/N TC-171Safford, AZ N751BRRockwell International 690B · S/N 11436Built 1977 · Safford, AZ N79BERockwell International 690B · S/N 11408Safford, AZ N92298Cessna 182N · S/N 18260137Built 1969 · Safford, AZ N93MERockwell International 690B · S/N 11414Built 1977 · Safford, AZ

Back to Ponderosa Aviation LLC