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 ('060005E')
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 ('060005E')
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.
N40LFExperimental Aircraft Association Inc · Oshkosh, WIN450RPParadise Boating Co · Chicago, ILN51986Experimental Aircraft Association Inc · Oshkosh, WIN5198YExperimental Aircraft Association Inc · Oshkosh, WIN5199DRainier Flight Service LLC · Renton, WAN5199KHiller Joseph · Port Orange, FLN52023M&L Flight Inc · Newcastle, WAN5202BRainier Flight Service LLC · Renton, WAN52030Hb963 LLC · Gig Harbor, WAN52040Robinson John · Auburn, NHN52049West Racer Ltd · Agoura Hills, CAN5204UCasiere Eugene A · Lake Hopatcong, NJN52054Ubelhor Blaine · Derby, INN52056206 Aviation LLC · Bainbridge Island, WAN5207BGuss Rigby Flight School LLC · Rigby, IDN5207RConfluence Systems Consulting · San Jose, CAN5207ZMcperng Aviation LLC · San Francisco, CAN5208VLa Flight School Inc · Van Nuys, CAN52092Beldue Richard J · Pittsboro, NCN5210ZSale Reported · Gainesville, FLSale reportedN52110Jhawk Aviation LLC · Leavenworth, KSN5211NFly America Inc · Palo Alto, CAN5211YM&L Flight Inc · Newcastle, WAN5212RMontana Interstate Air Transport LLC · Kalispell, MTN5212YM&L Flight Inc · Newcastle, WAN5213URegistration Pending · Bainbridge Island, WARegistration pendingN5214FRainier Flight Service LLC · Renton, WAN5215KFilkins Randy · Wellsburg, WVN52165Rainier Flight Service LLC · Renton, WAN5216LCorsair Aviation LLC · Pacoima, CAN5216NSkycatcher N162ah LLC · Santa Rosa, CAN5217XRodger That Aviation LLC · Arlington, TXN5689MKilo Mushroom Aeronautics Inc · Bellevue, WANon-citizen corporation, flight hours not reportedN589JDRainier Flight Service LLC · Renton, WAN6000UHorus LLC · Omaha, NEN60020Spirit Aviation Management Services Inc · Thomson, GAN6002GHirsch Hal E · Livermore, CAN6003FIonaj Inc · San Francisco, CAN6003PShorey Jonathan E · San Angelo, TXN60045Jackson Richard A · Cookeville, TNN6004ZCarlson Ashley · Galt, CAN6010TKansas State University · Salina, KSN6017KWillis Danny · Baldwyn, MSN6020YRainier Flight Service LLC · Renton, WAN60225Falcon Flight LLC · Las Vegas, NVN6026JN6026j LLC · Opa Locka, FLN6027AFlight World Inc · San Juan, PRN6027LRaskin Jack · Monroe, NJN6029GN6029g LLC · Manassas, VAN6029HBlair Nadine · Fleetwood, PA
Back to Cessna 162