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 ('8190112')
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 ('8190112')
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.
N1811KGage Lewis Trustee · Reno, NVN1812KMichaelsen Mark R · Leesburg, VAN1813KWilliams Jay P · Moses Lake, WAN1815BHaugen Michael C · Oklahoma City, OKN1816KCartledge Douglas J · Seville, OHN1822KSipple Ronald W Jr · Gardner, KSN1823KCooper Stephen · Fairbanks, AKN1825KSigler L Lanning · Albuquerque, NMN1829KGood Brian · Wildomar, CAN1830KCurry Gary D · Colorado Springs, CON1833KFarrell Brian K · Redding, CAN1835KEisen Noam D · Monsey, NYN1836KLapinsky Richard G · Los Lunas, NMN1838KLuscombe Endowment Holdings LLC · Gilbert, AZN1839KArmstrong Robert B · Bishop, GAN1840KSlack Jonathan D · Bonfield, ILN1847KConstantino Paulo · Brewster, NYN1849KMathieson Erik L · Kapowsin, WAN1850KShamlian Paul L · Fallon, NVN1858KGunder Craig R · Red Lion, PAN1860KDarby Jake B · Manila, ARN1862KGadis Ethan G · Etiwanda, CAN1868KRuddell Farms LLC · Junction City, ORN1869BKinach Virginia Ann Trustee · Laughlin, NVN1869KChiappini Paul · Melrose, FLN1880KObrien William D · Duluth, MNN1883KBolton Derwin B · Jacksonville, TXN18WSMason Loretta L · Cardington, OHN1902KBolton Derwin B · Jacksonville, TXN1908KHarding Nelson · Fort Jones, CAN1909BPuls Darrel E · Cotter, ARFirst renewal noticeN1910KHurlbert Vernon L · Anchorage, AKN1916KMagrini Shawn P · Salem, OHN1918KBrown Carl E · Milan, ILN1922KPrindle Steven E · Mililani, HIN1924KKnudson Andrew N · Tioga, NDN1929KSage Building Construction Inc · Roosevelt, UTN1934BDrake Randy L · Greenfield, INN1947KBender Evan D H · Linville, VAFirst renewal noticeN1949KLuscombe Endowment · Gilbert, AZN1954KLarson Daniel S · Chico, CAN1959KEllis Brenton M · Clarkesville, GAN1960KRussell John K · Graford, TXN1961KNeuzil Carl D · Dallas, TXN1968KAnderson Mark A · Bates City, MON1970KBentley Robert H · Lockport, ILN1971KThompson Roger L · Springfield, ILN1976KVessey Benjamin S · Fort Collins, CON1977KCartwright Edward N · Winterville, NCN1983KAutumn Crucus LLC · Cincinnati, OH
Back to Luscombe 8E