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.
N49153Witthuhn Johnie · Callaway, NEN49168Johnson William J · Wrightsville, GAN49170Brandt Terry R · Hood River, ORN49173Natalia John Angelo · Placerville, CAN49178Arctic Warbirds LLC · Anchorage, AKN49179Tansky Stanley S · Logan, OHN499MJohn Black LLC · Hurricane, UTN50048Zahm Liam · Marne, MIN50096Clarke Dan · Columbus, OHN50099Hohmann Courtney P · Jacksonville, FLN50107Stoverud Morten O · Vincentown, NJN50113Gries Charles J · South Barrington, ILN50121Rozendaal Douglas · Mason City, IAN50129Moffitt Larry A · Overland Park, KSN50290Eslick Peter O · Ocala, FLN50336Boyle Fred W · Cape May, NJN50369Moreus Steven P · Sunfish Lake, MNN50381Urlich Francis John · Jerome, IDFirst renewal noticeN50388Ross William J · Meridian, MSN50392Maxwell Douglas M · Brooks, GAN50399Phillips John D Executor · Montgomery, TXN50414Sottile Joseph S Trustee · Chandler, AZN50417Mcatee Kenneth · Evansville, INN50449Greene Ronald F · Mc Alpin, FLN50454Fudge James D · Niceville, FLN50569Rodberg Craig · Shakopee, MNN50573L-2 LLC · Overland Park, KSN50597Richards T D · Saint Jo, TXN50608Wiele Janet I · Wichita, KSN50767Mcguire Zach T · Jasper, MON50817Minard Richard O · Seattle, WAN50839Reid Robert W DBA · Independence, ORN50845Calloway Terry L · Protem, MON50862Barnes Roger A · Rogers, ARN50888Mcclymond Bruce · Ranchos De Taos, NMN50962Walker Stephen L Trustee · Andover, KSN50974Olson David W · Otho, IAN50980Obowa James K · Lino Lakes, MNN50982Chase Michael A · Humboldt, TNN51049Price Michael W · Elkton, VAN51366Allen Robert K · Dallas, TXN51378Fitch Beverly M · Levering, MIN51451Maley Christopher L · Otsego, MIN53534Clark Aircraft Repair Inc · Keokuk, IAN53709Hill Thomas D · Parma, IDN53712Young Gregory · Spring, TXN53760Miller Rodger F · Derby, KSN53765Miller Rodger F · Derby, KSN53771Alamo Liaison Group DBA · San Antonio, TXN53798Propit Inc · Wilmington, DE
Back to Taylorcraft DCO-65