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 ('8631802')
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 ('8631802')
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.
N1141Callaway Don · Leona Valley, CAN1187VGores Thomas J · Franklin, WIN13325Brown Michael D · Columbia, TNN1942WHangar 10 Flying Museum · Kingfisher, OKN1943SSouthern Aircraft Consultancy Inc Trustee · Casper, WYN279WCZabinski Ted W · Voorheesville, NYN33543Rossi Severin A · Cossonay VilleN36921Cook Thomas Dale · Chamberlain, SDN43YFLegacy Flight Museum City Of Rexburg · Rexburg, IDN444BFBoogerd Bartel Jay · Atoka, TNN4608NChilcott Bret · Derby, KSN46KWSkyhaven Airport Inc · Tunkhannock, PAN49252Wright Jeffrey C · Canby, ORN50227Taylor Carter · Los Angeles, CAN52028Keyes Richard A · Port Saint Lucie, FLN53547Collins John P · El Cajon, CAN5490NHughes David A · Keller, TXN55638Nimble Solutions Corp · Anchorage, AKN55939Fieldgrove Matt · Somerton, AZN55943Jacobi Joseph L II · Mexico, MON58285Shields Randolph C · Benton, KSN58571Stanger Joseph E · Willow, AKN59121Hickey Aero Services LLC · White Hills, AZN60058Valiair Lc Trustee · Casper, WYN60079Bacich Peter C · Brick, NJN60634American Airpower Heritage Flying Mu · Dallas, TXN60890White Edwin J · Avondale, PAN60924Interior & Arctic Alaska Aeronautical Foundation · Fairbanks, AKN61545Steele Aviation Inc · Walnut Cove, NCN64271Fischer Bruce M · Sun Prairie, WIN64435Egmond Aircraft LLC · Lewes, DEN64646Giddings Gavin J · Edgewater, MDN65002Schaus Richard H · Kalispell, MTN65019Gjm Inc · Wyalusing, PAN65345Greene Gary F · De Queen, ARN65442National Museum Of World War II Aviation · Colorado Springs, CON66096Tippit Larry J · Grand Prairie, TXN668FBPhillips Raymond B · Inver Grove, MNN67227American Airpower Heritage Flying Musuem · Dallas, TXN67617Bohon Todd R · Palmer, AKN69128Gullwing Aviation Holdings LLC · Lewes, DEN69245Handly William · Arcola, MSN69357Barnstormers Aero Services · Lompoc, CAN69386Fowler Gregory R · Poplar Grove, ILN69398Blaser Terry G · Menomonee Falls, WIN69416Gjm Inc · Wyalusing, PAN69418Registration Pending · Brighton, MIRegistration pendingN69430Lucci Giacinto A · Nashville, MIN69745Southern Aircraft Consultancy Inc Trustee · Casper, WYN69775Tall Timber Flying Service LLC · Kalispell, MT
Back to Stinson VULTEE V-77