Downer BELLANCA 14-19-3
Registered aircraft · 15
Aircraft of this model in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('3080116')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('3080116')
ORDER BY n_numberRun 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.
N470CMWooden Wings LLC · Prescott, AZN7610EGoode Stephen C · Canton, TXN7616ESellers Sean T · Minneapolis, MNN7634EGake Leland E · Vacaville, CAN7635ENu-Trans Inc · Johnston, IAN7641EPrentice Robert D · Ripon, WIN8814RLittle John L · Hamilton, TXN8827RPetet Ronald D · Payette, IDN8829RPierce Larry J · Brigham City, UTN8835RSwanland Robert C · San Jose, CAN8836RMead Donald W · Butte Meadows, CAN8843RKumor Ronald G · Casper, WYN8847RAnderson Stuart R Jr · Sahuarita, AZN8855RI-Five Inc · Carpenter, WYN8856RLighthouse Missions LLC · Montezuma, IA
Back to Downer BELLANCA 14-19-3