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.
N61866Wings Over Texas Holdings LLC · Denton, TXN61868Jamm Aircraft LLC · Sterling, OHN61870Dfu LLC · Boise, IDN61872Griffith William C III · Indianapolis, INN61873Umo Seneca LLC · Raleigh, NCN61875Knight Aviation I LLC · Prescott, AZN61876Ferrara James L Jr · Wellington, NVN61878Tate John M · Boonton, NJN61879Lake Elmo Aero LLC · Lake Elmo, MNN61884Purfield Sara E · West Richland, WAN61889Registration Pending · Dallas, PARegistration pendingN61890Stallion Leasing LLC · Louisville, KYN61891Higgins Jerome N · Oak Harbor, WAN61892Loughridge Robert M III · Prattville, ALN61901Lalaguna Ricardo · Orlando, FLN61915Economy Flying Club Inc · Cusick, WAN61922Chipman Roger M · Birch Harbor, MEN61923Northwoods Air LLC · Orono, MEN61925St Pete Aviation Services LLC · Saint Petersburg, FLN61928Borszich Claude C · Phoenix, AZN61933Geebee Ventures LLC · Belgrade, MTN61936Huffman David A · Oklahoma City, OKN61937Simplifly LLC · Mesa, AZN61943Phoenix Composite Solutions LLC · Oscoda, MIN61947Driggers Spencer A · Lake City, SCN61951Propability One LLC · Daytona Beach, FLN61953Smith Gregory D · Kalamazoo, MIN61960Dockins Jamie L · Athol, IDN61962Becker Jeremy R · Anchorage, AKN61967Pereira Jailton · Elizabeth, NJN61969Registered aircraftN61971Bayport Alumni Recreational Flyers LLC · Shirley, NYN61972Smtm Holdings Inc · Wilmington, DEN61973School Data Solutions Inc · Spokane, WAN61974Proclaim Aviation Ministries · Worthington, MNN61975Fern Sky LLC · Monroe Township, NJN61977Rdr Racing Inc · Latta, SCN61979Maciak Michael · Center Conway, NHN61982Airwatch LLC · Santa Rosa, CAN61985Wiltshire Henry C Jr · Plymouth, MAN61990Bauman William O · Abbeville, SCN61991Keime Parker · Show Low, AZN61994Mohawk Flying Club Inc · Ada, MIN622DLColorado Aircraft Corp · Watkins, CON628JCDelaney Patrick James · Marion, TXN629MMMcgraw Michael T · Gainesville, GAN62SMBell Charles S · Fort Payne, ALN630TCN630tc LLC · Nashville, TNN6392YBoldflight LLC · Greenwood, INN63SASky View Aviation LLC · Lenoir, NC
Back to Cessna 172M