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 ('0140202')
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 ('0140202')
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.
N3883XCallicoat Roger · Chesapeake, OHN3885XAgledor Bob Sr · Edgewater, FLN3887XAdams Kenneth Lee Jr · Jasper, GAN3897XRegistration Pending · Greenwood, INRegistration pendingN3898XWood Noah S · New Manchester, WVN4104XBandy Carla Sr · Texarkana, TXN4106XRossiter Andrew J · Vancouver, WAN4107XRedsun Oren Daniel · Fairfield, CAN4110XFoss Michael H · Niagara Falls, NYN4113XDyer Dillon G · Clatskanie, ORN4114XDaniel William G Jr · Penhook, VAN4115XCenterline Aero LLC · Kalispell, MTN4125XRedlion Asset Recovery LLC · Port Saint Lucie, FLN4126XTreat Michael F · Webster, WIN4129XHaines Robert E · Yukon, OKN4131XElite Fleet Jacksonville LLC · Jacksonville, FLN4133XAnfuso Keith · La Habra Heights, CAN4138XBroadwell Eric B · Woodstock, GAN4140XOtt Dean R · Carrollton, OHN4143XBoeing Co · Renton, WAN41460James Zoraida K · Paulden, AZN4146XOtt Dean R · Carrollton, OHN4153XWhite Gary C · Silverdale, WAN4156XChang Tim · Ocala, FLN4159XHagglund Carl D · Pendleton, ORN4169XNusom William J · Hollis Center, MEN5514MPruitt Buster Jr · Shelbyville, TNN5515MBarringer William R · Benbrook, TXN5535MButz Jonathan O · Mansfield, OHN5537MWiglesworth David G · Lenexa, KSN5541MDistrict School Board Of Pasco County · Land O Lakes, FLFirst renewal noticeN5545MMata Brian J · Sacramento, CAN5546MMathias Mark R · Gnadenhutten, OHN5550MHamblin Michael J · Seatac, WAN5559MBertelson Chester J · Modesto, CAN5560MA-1 Auto Reyclers · Columbia, MON5563MJudkovitz Shmuel · Brooklyn, NYN5567MAnderson Layne A · Wichita Falls, TXN5569MWichita Flight Training LLC · Wichita, KSN5570MFlythebat.Com LLC · Chicago, ILN5571MEdwards Larry N · Saint Joseph, MON5574MSimpson David B · Oakhurst, CAN6670DHudak Joseph III · Marco Island, FLFirst renewal noticeN9644CBybee John E · Burlington, IA
Back to Aero Commander 100