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 ('2072724')
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 ('2072724')
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.
N3135QGrf Aviation LLC · Destin, FLN3136QN3136q Flyers LLC · Las Vegas, NVN3138QShepard Donald · Lake Havasu City, AZN3139QGrubbs Jerry M · Longview, TXN3142QRogers James · Summerfield, FLN3143QJlm Management LLC · Clarion, PAN3144QRichmond Brian · Rhome, TXN3145QN3145q LLC · Cave Creek, AZN3146QJpw LLC · Red Lodge, MTN3147QBernbeck Alan R · Benton, KSN3151QRairdan Todd G · Vacaville, CAN3152QFff Aviation LLC · Land O Lakes, FLN3153QMaine Mold & Machine Inc · Hartford, MEN3155QLandro Rebecca · Puyallup, WAN3157QVowell Gregory · Coffeyville, KSN3164QHanson Donald R Jr · Hillsboro, NDN3165QNorris Benjamin · Zolfo Springs, FLN3170QRenfrow Denny · Kelseyville, CAN3174QMclaughlin Daniel R · Xenia, OHN3180QA & L Aircraft Holding LLC · Miami Springs, FLN3182QMagnusson Ralph L · Wyoming, MNN3183QMj Syndicate LLC · Vancouver, WAN3184QBeaugh Anthony H · Platteville, CON3185QPara Tactics LLC · Shelton, WAN3186QKimbril Steve · Hartselle, ALN3188QLutz Paul A Trustee · Seville, OHN3190QHilton John C · Glastonbury, CTN3192QSeel Jason L · Oak Creek, WIN323ACKing Ag Leasing Inc · Sudan, TXN3530FHeames Scott D · Simi Valley, CAN44441Breeden William N · Gaithersburg, MDN474BFDodson International Parts Inc · Rantoul, KSN47KSReiland Daniel E · Spring Valley, MNN5007WPeters Mark M · Chandler, AZN5112GCrawford Law Pllc · Selah, WAN5255KReighley Robert G · Xenia, OHN5393TTinseth Lance D Trustee · Highlands Ranch, CON5432VMj Aerial LLC · Wasilla, AKN553TAIctus Specialized Power Products Inc · Houston, TXN555MLSchramkowski Paul · Brentwood, TNN559AKBurton John · Nacogdoches, TXN55PFBurris Adam Eugene · Graham, WAN666JRUhl James Gustav · Ft Mckavett, TXN677YN677y Inc · Doylestown, PAN67KEGran Tulley Corp · Arcadia, FLN680RSoule Nathan A · Croswell, MIN7065JAmendt Inc · Sedgwick, CON70WBGraves Lucas M · Santa Rosa, CAN712TCTeasdale Gregg N · Genesee, IDN715GTTuttle Air Lc · Nashville, TN
Back to Cessna 182K