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 ('8050116')
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 ('8050116')
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.
N10379Havener Michael D · Murrieta, CAN126AOliver John F Trustee · Chula Vista, CAN126ERHobbs Martin Lowell · Old Fort, NCN12WTravis Dale E · Citrus Springs, FLN2701ZLessard George · Redlands, CAN2703ZFaultline Flyers · Leander, TXN2706ZHobbs Soaring Society Inc · Hobbs, NMN2710ZPalmquist Neal D · Homer, LAN2722ZCahill Dennis M · Albuquerque, NMN2754R219 Investments LLC · Miami, FLN2760RStewarts Aircraft Service · Waynesville, OHN2763ZHard Steven J · Mustang, OKN2767RAero Club Albatross · Blairstown, NJN3821ADaniel Gordon W · Dillsburg, PAN3822AFinger Lakes Soaring Club Inc · Dansville, NYN3825ACook Charles N · Fort Worth, TXN3830AWilliams Catherine A · Minden, NVN3838AStogner Michael E · Cubero, NMN3839AWalker William Hamilton · Bainbridge, GAN3852AJohnson Gustav M · Newton, NJN3853AMellies Thomas · Chestertown, MDN3854AEsser Paul H · Fairfield, CTN3855ATomco Stores Ltd · Ruidoso, NMN3856AHaskell Charles T · Atlanta, GAN3858ABryan Danny J · Hobbs, NMN3859AKellum Mark J · Belden, MSN3860AFreeland Chris G · Brownwood, TXN3861AMahony John · Ballston Spa, NYN3862AKendall Flying Services LLC · Miami, FLN3863ABradley David F · Lehighton, PAN3865AKecskes Stephen A · Austin, TXN3870ANorth Carolina Soaring Association · Zebulon, NCN3871AHilty Grant · Prescott Valley, AZN3873AHarvey Todd E · Erie, CON3874AMussman Craig · Grant Park, ILN3882ABowlsbey Bryan W · Mclean, VAN3884AVan Wormer Willard D · Leavenworth, KSN3886APalmquist Neal D · Homer, LAN3888AHoover Michael B · Ridgeland, WIN3903ANeidert Melvin E · Ulysses, KSN4041Walker Carol L · Ennis, TXN5700SPalmquist Neal D · Homer, LAN600XSaunders Christopher D · Lehighton, PAN7052UBailis David P · Bethlehem, PAN706ADKimbrel Mark D · Rochester, WAN771SYDaye Jeffrey E · Salisbury, NCN77WJDerrickson Jack N · Waynesville, OHN7926ABoldog Sandor Alex · Andalusia, ALN857ZCook Charles T · Angier, NCN8602RNorth Penn Squadron Soaring Assoc · Hatfield, PA
Back to Schweizer SGS 1-26A