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 ('2072434')
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 ('2072434')
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.
N734XCCurrier William R · Ormond Beach, FLN734XDByrne David · Three Rivers, MIN734XHFlyright Aviation Inc · North Las Vegas, NVN734XKEllig Todd L · Horace, NDN734XLWalsh Patrick Sean · Osterville, MAN734XMTri Star Cac LLC · Plano, TXN734XPDutcher John A · Cedar Falls, IAN734XQSumter County Sheriffs Office · Sumter, SCN734XRWingsleasing LLC · Wichita, KSN734XSCrabtree Clifford I · Ukiah, CAN734XTFlying Colors Airparts Inc · Leesburg, FLN734XXHuerta Holdings Inc · Santa Ana, CAN734XYBend Aircraft Mechanics LLC · Bend, ORN734YALuxair LLC · College Station, TXN734YBHrbk LLC · Grandview, INN734YCShaw Terry R · Olympia, WAN734YDWings Over Texas Holdings LLC · Denton, TXN734YLTactical Integrated Training Solutions LLC · San Antonio, TXN734YMStockbridge Valley Flying Club Inc · Syracuse, NYN734YVHarvey David C · Wellsboro, PAN734YXKvalita John C Jr · Port Charlotte, FLN734ZAHanson Brian · Sauk City, WIN734ZBCurten Clay A · Evansville, ILN734ZCGeorges Aviation Services Inc · Honolulu, HIN734ZGHorn Norman R · Las Vegas, NVN734ZKDockins Jamie · Athol, IDN734ZQMidway Flying Club Inc · Attleboro, MAN734ZTWatauga Eagle Squadron Foundation · Elizabethton, TNN734ZVWesellairplanes Com Inc · Wilmington, DEN734ZYWings Over Texas Holdings LLC · Denton, TXN7350JVero Technical Support Inc · Pensacola, FLN7352DStrickland James M Jr · Whiteville, NCN7363EWilkins Raymond E · Osceola, IAN73654Alaska Star Flying Club · Wasilla, AKN73657Davis John M · Middletown, DEN73660Hancock Brian · Edmond, OKN73662Flores Francisco H · Avondale, AZN7366DMh Aviation Inc · Lancaster, CAN7366FDesantos Rance · Baldwin, NYN73671Registered aircraftN7367EGregg Flying Service Inc · Durango, CON7367FDuffys Aircraft Sales And Leasing Inc · Neillsville, WIN73686Falcon Aviation Inc · Farmington Hills, MIN7368FW Tech Consulting Inc · Wilmington, DEN7368JDylan Branch LLC · Tomball, TXN73702Shiles Darrel J · Baltimore, MDN73707Leading Edge Flight Academy LLC · Bend, ORN73719Purdue Aviation LLC · West Lafayette, INN73726Wings Over Texas Holdings LLC · Denton, TXN73728Crowe Robert B · Del Valle, TX
Back to Cessna 172N