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 ('0191006')
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 ('0191006')
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.
N49059Ray Charlie B · Prosser, WAN49110Chimera Air Inc · Maumee, OHN49114Brewer Stephen F · Hamilton, OHN49116Brown Eric J · Belle Plaine, MNN49117Hone Dick · Enterprise, ORN49152Price John M · Plainfield, NJN49176Cooper Alvin W · Petaluma, CAN49217Tuck David William · Seattle, WAN49271Tarpley Timothy A Trustee · Dallas, ORN49302Littlefield Keith A · Kent, WAN49304Nelson Craig M · Eastsound, WAN49510Davis Lloyd L Jr · Brackettville, TXN49545Jackson Robert J · Ranger, TXN49705Dickens Todd H · Morganton, NCN49847Wilson Lyndon K Sr · Ringgold, GAN50333Hardy Randall B · Argyle, TXN50334Airpower Museum Inc · Ottumwa, IAN50725Eaa Chapter 67 Inc · Noblesville, INN50726Montgomery Christopher S · Appleton, WIN53788Silva Gary DBA · Yerington, NVN56733Urlich Francis J · Jerome, IDN56740Mctaggart Briar C · Adelanto, CAN57714Reynolds Jeffrey S · Flower Mound, TXN5807NLandergood Aviation LLC · Smithville, TNN59451Registered aircraftN59812Slayden Steven M · Rhome, TXN64482Hoffman Dylan R · Nazareth, PAN67756Sleepy Hollow Aero Group LLC · Fredericksburg, VAN77501Beckman Jeffrey A · Temecula, CAN777BXHawley Luther S · Saint Matthews, SCN79557James Roger L · New Carlisle, OHN88BZSimpson Larry D · Manito, IL
Back to Aeronca 0-58B