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 ('2072418')
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 ('2072418')
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.
N66GVPearson Robert L IV · Spartanburg, SCN66MMTake Flyt LLC · Eagle Lake, MNN6700HNashua Flyers Inc · Nashua, NHN6702HGoetz Terry L · Defiance, IAN6706HDairy Air Inc · Wyoming, PAN6707HWjt Investments LLC · Gurley, ALN6727HAldora Enterprise LLC · League City, TXN6735HWhitney Dudley P · Windsor, VTN6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCN6747HAurora Skyhawks · Portland, ORN6748HN6748h LLC · Palm Beach Gardens, FLN6750HPickett Michael R · Gig Harbor, WAN6758HGorge Winds Aviation Inc · Fairview, ORN676CHTake Off Aviation Services LLC · Rockledge, FLN6780HMerrell Shane F · Shelby, ALN6782HJb Aviation Management Inc · Wonder Lake, ILN6787HGordon Caleb J · Waukesha, WIN6794HPs N6794h LLC · Green Bay, WIN6796HAmelia Reid Aviation LLC · San Jose, CAN6798HWnk Leasing LLC · Lewes, DEN6800HBlack Industries LLC · Helena, MTN6802HAirline Transport Professionals Corp Of USA · Wilmington, DEN6811HJohnson Larry P Jr · Waynesville, GAN6814HUniform Gulf Aviation LLC · Williamstown, NJN6823HClay Howard C II · San Francisco, CAN6831HQuarry Jon C · Memphis, TNN6835HIowa Lakes Community College · Estherville, IAN6843HWhitefish Mountain Acft Rentals And Flt School LLC · Whitefish, MTN6852HSetter Jory · Midvale, UTN6853HJohnson Seth W · North Pole, AKN6854HN6854h LLC · Opa Locka, FLN6857HNew Mexico Flying Eagle Inc · Tucson, AZN6858HPrairie Skies Aviation LLC · Hutchinson, KSN6859HRoeper Gary Lee · Linden, MIN6860HUniversity Of Michigan Flyers · Ann Arbor, MIN6861HViking Systems Inc · Naples, FLN6862HStrickland J A · Fairbanks, AKN6863TBering Capital LLC · Anchorage, AKN6864HMay Jeffrey N · Ocala, FLN6866HParrish Michael C Trustee · Lakeland, FLN6876HSt Charles County Flying Club LLC · Portage Des Sioux, MON6877HKoenig Ned · New Bremen, OHN6884HWings Over Texas Holdings LLC · Denton, TXN6885HRasmussen Stewart · Santa Barbara, CAN6886HParr Larry · Clarksville, TNN6888HN6888h LLC · Wayne, NJN688CABetter Southlake Properties LLC · Pagosa Springs, CON6891HRegistration Pending · Uvalde, TXRegistration pendingN6896HBuiqui Aerospace Corp · Kissimmee, FLN6898HS J Holding LLC · Wilmington, DE
Back to Cessna 172M