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 ('8850350')
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 ('8850350')
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.
N24426Podeweltz Dana A · Merrill, WIN24466Clausen John R · San Antonio, TXN24479Casady Kent B · San Diego, CAN24487Popp Walter E · Grand Junction, CON26513Caviris Charles N · Rollinsford, NHN26528Robinson Michael E · Chandler, AZN26531Allred Gina D Administrator · Centre, ALN26543Mcconnell Wayne L · Cottonwood, CAN26551Havis Rex V · Crowley, TXN26576Werbelow Brothers Partnership · Greybull, WYN26594Combs Jonathan Randall · Girdwood, AKN26645Morton Marvin E · Cambridge Springs, PAN26651Edwards Joseph Morton III · Monument, CON26653Lairson David W · Dayton, TXN26677Meinen Max W · Grandview, TXN26680Dec James T · Cayuga, NYN26683Stinebring Brad L · Columbus, INN26687Petro Jerry R · Williamsburg, VAN27412Johnson Gary I · Minot, NDN27414Cox Aaron D · Kalama, WAN27416Adkins Robert · Vinton, OHN27433Morgan Jeff P · Justin, TXN27440Paul Wesley J · Willow, AKN27452Cook Franklin · Baraboo, WIN27461Topp William J · Marion, KYN27468Smith Carol J Executrix · Gilbertsville, KYN27473Reid Robert W · Independence, ORN27487Van Winkle Randy M · Van Buren, MON27488Bradford Murvin L · Hensley, ARN27489Routh Frank D · Marion, NCN27492Blazer Stephen W · Easton, MON27499Nichols William O · Claypool, INN27504Newlin Galen · Searcy, ARN27517Thomas Mark A · Edmonton, KYN27536Wacker George F Trustee · Los Angeles, CAN27571Ellis Grover D · Sanford, NCN27580Mann Thomas A · Ford, WAN275NBKrabill Isaac J · Halsey, ORN27632Mason Mark W · Pleasant Prairie, WIN27638Via Johnnie W · Atascadero, CAN27639Kiehl Timothy A · Glendale, AZN27649Cunningham Zachery T · York, PAN27652Bilstad Jacob A · Plano, TXN27657Braness Jim G · Richmond, MNN27684Hadley Everett F · Dayville, CTN27698Buchanan Thomas K Jr · Russellville, TNN29504Sale Reported · Clintonville, WISale reportedN29506Skinner Norman D · Osceola, IAN29508Jacob Trevor · Mammoth Lakes, CAN29544Naber David L · Fairbanks, AK
Back to Taylorcraft BL-65