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 ('9230402')
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 ('9230402')
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.
N97234Dean Philip M · Anna, TXN97235Anderson Lee George · Wichita, KSN97245Atteberry Jake D · Mooresville, NCN97256Mineart Stephen M · Oskaloosa, IAN97260Wilkins Jamison M · Salt Lake City, UTN97275Burkel Robert G · Hemet, CAN97289Vlk Mark J · Odessa, WAN97290Puddle Jumpers Flying Club Inc · Interlochen, MIN97301Macglover Christopher Aw · Laramie, WYN97305Miller Gregory L · Loudonville, OHN97332Koenig Robert O · Fairbanks, AKN97338Rud Philip · Clara City, MNN97341Pittman Jerry L · Nashville, INN97343Whelpley Michael L · Twin Lake, MIN97346Becker David J · Austin, TXN97348Registration Pending · Prescott, AZRegistration pendingN97354Sheets Wayne H · Hagaman, NYN97367Alg Management And Leasing Company LLC · Little Rock, ARN97368Hitt Zachary T · Whitingham, VTN97372Reek David A · Emmett, IDN97389Pennuto Kurt T · Berthoud, CON97403Warren Howard E · Cookeville, TNN97405Hiner Hugh Dennis · Angola, INN97408Taylor Douglas B · New Middletown, OHN97411Bourland Randal L · Floresville, TXN97415Farwell Richard D Jr · Albion, NYN97431Yeager Gary J · Cheney, WAN97432Voyager Flying LLC · Bemidji, MNFirst renewal noticeN97438Registration Pending · Chugiak, AKRegistration pendingN97440Treichler Peter DBA · East Aurora, NYN97454Richards David S III · Eagle Creek, ORN97458Van Devanter Alan R · Springboro, OHN97463Flint Harry L · Falls City, NEN97468Totten Debra A Executor · Carroll, OHN97470Odendaal Martin J · Maryville, TNN97479Schultz Howard G · Santa Rosa, CAN97480Rockhut Aviation LLC · Abilene, TXN97482Sisskin Enid E · Gulf Breeze, FLN97486Myer Charles G · Forest Lake, MNN97491Registration Pending · Lewes, DERegistration pending, pending cancellationN97501Turnage Matthew · Clarence, MON97504H&A Aircraft Services LLC · Omaha, ARN97507Dinucci Jeffrey J · Luthersville, GAN97516Hanusin Mark · Huntley, ILN97517Adams John C Trustee · Malvern, OHN97518Still Douglas A · Yorktown, VAN97520Guehr Helmut Jr · Winston-Salem, NCN97526Guillen Sergio Balvino · Rancho Murieta, CAN97531Love William F · Ransomville, NYN97535Ruppert Thomas E · Fairbanks, AK
Back to Stinson 108