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 ('2076802')
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 ('2076802')
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.
N640RBTalfin Leasing II LLC · Heflin, ALN650ABBank Of Utah Trustee · Salt Lake City, UTN650ACTen X Express LLC · Fort Myers, FLN650AHNice Trip LLC · San Juan, PRN650ASSky Bus Inc · North Miami Beach, FLN650ATN650at LLC · Punta Gorda, FLN650CBSzucs Attila · Port Orange, FLN650CGC G Bretting Manufacturing Co Inc · Ashland, WIN650CJViggiano Aviation LLC · New Haven, INN650CZTeam Aero LLC · Shawnee, KSN650FCOrion Igv LLC · Opa-Locka, FLN650GCBank Of Utah Trustee · Salt Lake City, UTN650HGHamlin Aviation LLC · Ormond Beach, FLN650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKN650JLEncore Jet Management LLC · San Antonio, TXN650KPJt95 Airways LLC · Concord, CAN650PFAircraft Holding Solutions LLC Trustee · Newark, DEN650PJSouthwest Aviation Inc · Marshall, MNN650PTBurkim LLC · Hartland, WIN650RARomeo Alpha LLC · Addison, TXN650RCRosado William · Moosic, PAN650RPRussell Air LLC · Madison, INN650RTGlobal Aero Aviation Inc · Houston, TXN650SFBas Part Sales LLC · Greeley, CON650SGMerlin One Aircraft LLC · San Antonio, TXN650TASale Reported · Greeley, COSale reported, pending cancellationN650TWKwafr LLC · Richland Hills, TXN650WMerlin One Aircraft LLC · San Antonio, TXN650WAWings Aloft Incorporated · Portland, ORN650WTRiver Bay Aviation N650wt LLC · Jacksonville, FLN651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN651CVAlvista Aviation LLC · Lewes, DEN651EJComprehensive Energy Aviation LLC · Longwood, FLN651EMWv Jet Experience LLC · Charleston, WVN651SFN444cw Partners LLC · Spring, TXN652CCSu-N16 LLC · Oak Creek, WIN653CCRegistered aircraftN657TCrush72 Inc · Wilmington, DEN660PAFriendly Aviation LLC · Dallas, TXN664MMAquarius Aircraft Leasing LLC · Nashville, TNN67FSBank Of Utah Trustee · Salt Lake City, UTN682RSAircraft Resource Center Inc · Lakeville, MNN689WTotal Prf LLC · Lewes, DEN700LWAircraft Resource Center Inc · Lakeville, MNN700MHMotor City Aeronautics LLC · Okemos, MIN702SMTeam Aero LLC · Olathe, KSN710VPTx N710vp LLC · Austin, TXN711GFIpo II LLC · Wheeling, ILN711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLN725RHEstancia Aviation III LLC · Reno, NV
Back to Cessna 650