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 ('2072722')
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 ('2072722')
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.
N404SMForm 50 Aviation LLC · Newark, DEN40ECHill Richard C · Buckeye, AZN428HSSchroebel John Daniel Trustee · Pleasant Hill, CAN4303SCartersfly LLC · Lewes, DEN43TBAndreu Kenneth · Valhalla, NYN44JGLiberty Industries LLC · Washington, DCN45LLLangebrake Lawrence C · Saint Petersburg, FLN460WPoling Barry · Texline, TXN47DUTomlin Trevor · Huber Heights, OHN498EKSpc Aviation LLC · Washington, DCN501DSChilson Jacob Shane · Willits, CAN501GEPhillips Matthew D · Astoria, ORN51472Breaks Bound LLC · Kalispell, MTN54RWBaylis Thomas B · Hattiesburg, MSN5670R&R Aircraft LLC · Chugiak, AKN594CF4cf Partnership · Fall River Mills, CAN6061TForgues Inc · Wilmington, DEN624CGChristy Alan · Pendleton, ORN6398DAdx Holdings Lp · Marble Falls, TXN642ABauer Thomas M · Elizabethtown, KYN65PKOlson'S Excavating Inc · Cascade, IDN677RDWise Timothy L · Quinton, OKN777ZCDiversified Refrigeration Co · Lino Lakes, MNN787DAMeade Gregory J · Santa Margarita, CAN79BBRegistration Pending · Wilmington, DERegistration pendingN800MLNaples LLC · Mound City, MON831CBSummersell Steven K · Pensacola, FLN8585SPreszler Terry J · Richland, WAN8591SRivera Carlos A · Beach Park, ILN8598SBradley Christopher J · Left Hand, WVN8599SMcclung Malcolm J · Ripon, WIN85NEvans Thomas P · Hollow Rock, TNN88RKJkg LLC · Idaho Falls, IDN89JFWitt Roger S · Spencer, MAN91066King D Kenyon · Chatham, NHN93BZMoreno Joseph L · San Diego, CAN966STAbc Builders LLC · Merritt Island, FLN9924AAbner Cody J · Cleburne, TX
Back to Cessna 182J