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.
N97537Wright Rob C · Omaha, NEN97538Cushing Aero Service Inc · Red Wing, MNN97548Domeyer David K · Washougal, WAN97554Mcelhaney Andrew R · Roy, WAN97555Wawrzyniak James S · North Myrtle Beach, SCN97558Howell Aviation LLC · Orlando, FLN97566Fortson Thomas Allen · Saint Regis, MTN97567Scanes Jeffrey D · West Chester, PAN97568Peregrinus Solutions LLC · Jamesville, NYN97572Ferrell Herman H · Oak Grove, LAN97575Obrien Patrick J · Santa Paula, CAN97577Corbin Roger T · New Braunfels, TXN97581Burklund Steven T · Milaca, MNN97586Fleurent Ronald G · Biddeford, MEN97591Western North Carolina Air Museum · Hendersonville, NCN97595Lucy Douglas S · Apple Valley, CAN97599Airport Farms Aviation LLC · Tarkio, MON97603Registered aircraftN97605Kehler Justin A · Skiatook, OKN97606Van Farowe Gary A · Hudsonville, MIN97607Pasta Kyle H · Wasilla, AKN97610Craigmyle William R · Cooperstown, NYN97614Osentowski Louis E · Paxton, NEN97616Greenland Terry L · Rockford, MIN97617Stout Larry E · Winamac, INN97619Showers Scott · Ithaca, MIN97626Culler John · Arvada, CON97628Spore Raymond W Trustee · Davis, CAFirst renewal noticeN97634Zigmond Jeremy D · San Antonio, TXN97635Airport Farms Aviation LLC · Tarkio, MON97647Suryan Matthew R · Port Townsend, WAFirst renewal noticeN97651Ramstad Craig · Wellington, NVN97652Hockman James C · Strasburg, VAN97653Handly William A · Arcola, MSN97654Laird Charles L · Adelanto, CAN97656Leclere Dwight D · Coggon, IAN97663Bjornstad Paul Andrew · Minden, NVN97666Van Koevering Dennis J · Hudsonville, MIN97679Captain Meadows LLC · Ozark, MON97686Pemberton David T · Haughton, LAN97689Gerardi Joseph F · Staten Island, NYN97692Van Surdam John R · Seneca, SCN97693Stanton Thomas W · Brookings, SDN97694Schultz Daniel A · Tipp City, OHN97695Hill Dennis B · Lincoln, CAN97697Downey Deborah A · Chesterland, OHN97699Strong Keith Alan · Fresno, CAN97703Bellamy John Mark · Freeville, NYN97716Taylor David A · Everett, WAN97719Sutton Aircraft Salvage LLC · Palmer, AK
Back to Stinson 108