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 ('2072420')
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 ('2072420')
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.
N5751RKummer Brian · Port Orange, FLN5755REshbaugh Melvin L · Topeka, KSN5756RCm3 LLC · North Las Vegas, NVN5759RP & R Aviation LLC · Edenton, NCN5767RSelf Averill L · Campbell, TXN5768RAllenray Corp · Otsego, MIN5769RLatimer Francis E · Washingtonville, NYN5770RFurge David T · Brookton, MEN5771RWilson Bach Myrl · Piedmont, SCN5773REnev Ivan E · Wood Dale, ILN5774RBallard Thomas L · Seguin, TXN5776RKatri Thomas L · Conroe, TXN5777RSumner Gary W · Knoxville, TNN5781RFeauto Aviation Inc · Saint Cloud, FLN5782RSchuck Daniel W · Newark, CAN5783RPritting John R · Reno, NVN5785RKablau Frank · Elroy, WIN5786RBrown Jeremiah S · Ada, OHN5789RShipley Lucas S · Jefferson, IAN5790RMiller Cindy C · San Ramon, CAN5792RCollins Mark W · Seymour, TNN5793RRogers Jesse E · La Belle, MON5794RMacfarland Donald C · North Tonawanda, NYN5797RRiggs Laura A · Middleburg, FLN5798RRatcliff Bruce A · Plain City, OHN5800RPomeroy Cattle Ranch LLC · Kalispell, MTN5802RMiller Chris D · Collierville, TNN5804RGriffin David Charles · Palmyra, PAN5807RYoung Darrin · Chillicothe, MON5809RJ L S Agency LLC · Starkville, MSN5811RGreat Plains Enterprises LLC · Wilmington, OHN5812RPeterson Bruce G · Saint Cloud, MNN5814RBrown Jacob M · Boswell, PAN5815RLambson Roger · Saint Ignatius, MTN5816RLittle Bird Airways LLC · Hamburg, NYN5818RVanthof Douglas D · Sioux Falls, SDN5851RSmoky Bear Air LLC · Rockwood, TNN5852RBenien Dennis A · Napoleon, OHN5853RHall Gary M · Muncie, INN5855RDonelan Matt B · Springfield, ILN5857RWaypoint Equipment LLC · Mckinney, TXN5858RNitz Terry L · Fredericksburg, VAN5860RSkyhawk Ventures LLC · Boise, IDN5862RMcgowan Keegan M · San Antonio, TXN5864RBattle Proven Leadership LLC · Crown Point, INN5866RNeal Edward K · Laud By Sea, FLN5867RGoatley John E · Springfield, KYN5868RRizzo John M Sr · Sugar Land, TXN5872RMckee Joseph R · Godfrey, ILN5873R3 Points LLC · Comstock Park, MI
Back to Cessna 172G