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 ('2072604')
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 ('2072604')
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.
N5023EHarned William C · Lebanon Junction, KYN5027EMeister James E · New Richmond, WIN5034EBurns Joyce A · Sparta, MON5037EDevore James L · Carmichael, CAN5209DBens Travel Gear LLC · Mountain Home, ARN5210DLeitch Robert F · San Jose, CAN5212DVanderpool Celia C · San Clemente, CAN5214DMarlatt Earl D · Yuma, AZN5216DSixty North LLC · Boise, IDN521VTSeaplanes R Fun Inc · Wilmington, DEN5224DMoreland Aviation Enterprises Inc · Byron, ILN5231DDixon Douglas C · Anchorage, AKN5235DP2i Real Estate Ltd · Shreveport, LAN5236DSpiro Paul M · Anchorage, AKN5238DLewis Mechanical Inc · Wasilla, AKN5239DBatista Caleb · Beckley, WVN5240DBailey Carlton D Jr · Huntington, WVN5243DStoltzfus Sandra · Kidron, OHN5244DMalnarick Kyce S · Anchorage, AKN5250DRyan Justin E · King Salmon, AKN5252DGullwing Research LLC · Willow, AKN5270DGibson Brenton D · Siletz, ORN5273DDrath Mark O · Reedsville, WIN5274DSimonsen Deanne M · White Salmon, WAN5275DWorrell Sharyl L · Anchorage, AKN5281DRocky Pointe Logistics LLC · Hayden, IDN5285DBarker Aviation LLC · Ardmore, OKN5287DWitham Kyle S · Lakeview, ORN5291DJacobson Anthony P · Wasilla, AKN5304DDelta Enterprises LLC · Kasilof, AKN5309DPotter John · Payson, UTN5316DErickson Todd E · Wasilla, AKN5318DBolton Frederick J · Willow, AKN5326DHiebert Nathan D · Newton, KSN5327DPiekarski John S · Wichita Falls, TXN5332DLeibovitz Joshua · Portland, ORN5343DHusnik Brad M · Forest Lake, MNN5351DSplan David L · Mccall, IDN5353DMcmahan Charles B · Gakona, AKN5355DFischer Alfred M DBA · Genoa City, WIN5361DPannone Steven R · Palmer, AKN5366DHeinrich Rivero Hinze Max · San Antonio, TXN5367DBandrowicz Leon A · Shelby, MIN5369DBrown Hector M · Glenwood Springs, CON5370DWhitten Wayne M Sr · North Berwick, MEN5372DHanks Don N · Eagle River, AKN5374DMoreau Clair L Jr · South Portland, MEN5375DRamstad Trygg J · Anchorage, AKN5381DSchallip Robert G Jr · Barbeau, MIN5389DRegistered aircraft
Back to Cessna 180A