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 ('8850408')
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 ('8850408')
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.
N47454Casady Kent · San Diego, CAN47464Nichols Jan L · Bonham, TXN47468Tomlin Jonathan S · Georgetown, OHN47478Hillman Edward Jr · Alliance, OHN47481Huff Roger A · Johnstown, OHN47486Prather Carl L · Gilroy, CAN47504Cramer Todd L · Fort Mohave, AZN47547Farmer Larry A Trustee · Salina, KSN4754KMoss Mark · Richburg, SCN47581Batesel Floyd O · Independence, MON47585Hall Larry R · Whitesboro, TXN47625Mccaslin Dale A Trustee · Holt, MON47648Carter Russell W · Anchorage, AKN47655Fulenchek Raymond D · Sherman, TXN47724Wacker George F Trustee · Los Angeles, CAN47727Letrello Michael F · Saint Charles, MON47730Good Edward S · East Falmouth, MAN47731Brownsville Barnstormers Flying Museum Inc · Brownsville, TXN47825Steiger Jon Patrick · Friendswood, TXN47867Old Aeroplane Co LLC · Lake Suzy, FLN48088Agaliotis Paul E · San Martin, CAN48247Army Aviation Publications Inc · Monroe, CTN48268Chattaway Bradford T · Stockbridge, MIN48274Holston David J · San Diego, CAN48276Vermeer Donald I · Port Charlotte, FLN48291Agather Victor Neils · Fort Worth, TXN48346Moreus Steven P · Sunfish Lake, MNN48349South Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDN48350Goebel William R · Rhome, TXN48389Glenn William C · Marion, NCN48391Lamb David W · Ellerbe, NCN48393Young Gregory · Spring, TXN48446Masini Joseph E · Hancock, MIN48462George Donald J · Springfield, ILN48603Agaliotis Paul E · San Martin, CAN4862Henry Erick L · Aydlett, NCN48634Wasik Marvin B · Hernando, FLN48644Schoellig Mark J · Burlington Flats, NYN48818Bugsmashers Inc · Atascadero, CAN48832Smith Louis D · Independence, ORN48866Calloway Terry · Protem, MON48923Picard Robert D · Anchor Point, AKN49000Simply Living LLC · Fort Myers, FLN49019Benner James M · Great Falls, MTN49023Romar Mitchel D · Massillon, OHN49040West Anthony L · Cumming, GAN49119Hammond Sidney G · Abilene, KSN49122Piercy Ronald S · Moses Lake, WAN49136Lind Ronald C · Rainier, WAN49137Schermerhorn Charles L · Orcutt, CA
Back to Taylorcraft DCO-65