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 ('2071826')
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 ('2071826')
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.
N6657GLlw Outlaw Trucking LLC · Iola, TXN6661GMcleod Cecil · Mount Pleasant, SCN666MGGragg Mervyn C · East Wenatchee, WAN6674GJoe Dory Aviation LLC · Caldwell, IDN6676GChen Hong · Independence, ORN6681GMoore Joseph L · Hesperus, CON6683GPardee Gary D · Buckley, WAN6684GReeder Brenton Lamar · Beacon, NYN6692GHopkins Marissa A · Cameron, MTN6694GChatas John W · Ann Arbor, MIN6697GPaul William A · Windfall, INN6699GBailey Matthew T · Cornelius, ORN6704GRyan Conner J · Fruita, CON6708GRussell Gary W · Martinsburg, WVN6710GShelton Dale E · West Frankfort, ILN6715GCardwell Aubrey Lynn · Spring Branch, TXN6717GJet Airways Express Inc · Aventura, FLN6720GMcclintick Marshall Wyatt · Daniel Island, SCN6722GPiasa Flyers Inc · East Alton, ILN6723GPressley Brandon S · York, SCN6725GJohnson Andrew E · Prior Lake, MNN6729GBelgacem Yassine · Harrisburg, PAN6733GAsaro Carlo · Waterbury, CTN6735GRedeemed Flying Corps Association · Oklahoma City, OKN6738GSpark Aero LLC · Christiansburg, VAN673CBBurge Jerome C · Thousand Oaks, CAN6744GRenfrow Denny M · Kelseyville, CAN6746GKelsay Roger B · Hillsboro, ORN6750GWimberly Fred N · Callao, VAN6752GKucharyk Roman · Mount Airy, MDN6755GByler James H · Belleville, PAN6758GTaylor Paul E · Jonesville, MIFirst renewal noticeN6760GPurkinje Ltd LLC · Wilmington, DEN6763GVarner David L · Eastpoint, FLN6767GAspen Kelsen LLC · Rutledge, MON6775GBannock Anthony O · Anchorage, AKN6776GWalters John S · Durham, CAN6782GWilson Zachary R · Richland Center, WIFirst renewal noticeN6790GMartin Christopher G · Monessen, PAN6793GExecutive Flight Institute LLC · Murrieta, CAN6794GLawson Kurt J · Melbourne, FLN6796GLyon Scott T · Wellsville, KSN6798GCowan Ronnie C · Glasgow, KYN6799GWetzler Brian · Bainbridge Island, WAN67WJBusiness As Usual LLC · Spartanburg, SCN6801GDelta Ridge Farms LLC · Oak Grove, LAN6802GFry John W · Vinita, OKN6806GHigley Paul D · Redding, CAN6807GOriginal Design Ministries DBA · Eatonville, WAN6808GJewell Daniel J · Texarkana, AR
Back to Cessna 150L