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 ('9230104')
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 ('9230104')
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.
N78070Visscher Paul J · Madison, GAN78071Steadman John M · Mobile, ALN78074Bartholomew Donald B · Gardnerville, NVN78077Jensen Aviation Inc · South Haven, MIN78082Andersen Allen E · Sandy Valley, NVN78083Holcomb Garry · Point, TXN78088Neville Aviation Inc · Marianna, FLN78096Bell Michael S · Trinity, TXN78099Daniel Gordon · Dillsburg, PAN78103Johanson Karl S · San Diego, CAN78104Stanley George W · Richland, WAN78109Hockett Patricia A Trustee · Granbury, TXN78113Hardy John R · Wasilla, AKN78116Sweeney Sean M · Reunion, FLN78118Cubswift LLC · San Antonio, TXN78120Stinson Jeremy L · Douglas, GAN78121Texas Airtime LLC · Fort Worth, TXN78127Brown Asa V Jr · Royston, GAN78131Meyers Jess Hugh · Las Vegas, NVN78134Vetter Virgil R · Plattsburg, MON78136Steinbock Richard J · Klamath Falls, ORN78137Carpenter David M · Berea, KYN78140Shields Edwin G · York, SCN78150Dreyer Elwain C · Cardington, OHN78153Parnell-Davis Paula A · La Center, WAN78165Hostler James A · Eastsound, WAN78170Schuster Doug B · Upland, CAN78171Losasso Adam · Scottsdale, AZN78176Fawcett Walter L · Wolfeboro, NHN78181Brookway Aviation LLC · Brookhaven, MSN78188Stein John R · Central Lake, MIN78191Hamilton Kirk G · Fargo, NDN78193Troxell Jay C · Hatfield, PAN78194Kolstad Anna · Hartland, WIN78199Pearce Evan W · West Lafayette, INN78204Gillaspie Wade D Jr · Huntsville, TXN78209Walker Ray A · Sanger, TXN78218Holliday Mark E · Lake Elmo, MNN78223Jackson Johnny E · Jackson, GAN78225Holliday Mark E · Lake Elmo, MNN78230Hathy Albert J · Helena, MTN78231Moriarty Joseph B Jr · Madbury, NHN78237Spencer Randall Bruce · Orangeville, UTN78238Weaver William B · Vancouver, WAN78244Schick Joleen G · Phoenix, AZN78251Barnett Paul S · Brookhaven, MSN78256Ohnstad Kevin J · Argusville, NDN78267Fenton Harry L · Rockton, ILN78270Jones Allan M · Miamisburg, OHN78275Bartosh Larry M · Abbott, TX
Back to Globe GC-1B