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 ('7103207')
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 ('7103207')
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.
N100LWN100lw LLC · Hickory, NCN106GWWevodau Gerry R Jr · Enola, PAN106MRIsland Flights Inc · Wilmington, DEN110WTW T Aviation LLC · Wichita, KSN114ELNaperville Flying Club · Woodridge, ILN117JCHillsboro Flying Club · Hillsboro, ORN11YTAnm Air LLC · Grimes, IAN137SDHann Joseph C · Flemington, NJN146SWFairway Systems LLC · New Port Richey, FLN153MKThomas Paul · Falls Church, VAN15KFH Aviation LLC · Celina, TXN186SXRodarte Luis Manuel Jr · Tomball, TXN18WMIsland Cay Express Inc · Wilmington, DEN22GJTaffet Jay · New Orleans, LAN22UTMomentum Foundation · Tullahoma, TNN239AShiloh Flite Five · Eden, NCN247GWRotondo Joseph N · Baden, PAN2510XRegistration Pending · West Hartford, CTRegistration pendingN258SCBlue Border LLC · Blue Earth, MNN300BHGreen Valley Corporation I · San Jose, CAN300UMMurray Air LLC · Patoka, ILN301PS3b1g Enterprises LLC · Phoenix, AZN3280QDakota Acre Farms Inc · Denhoff, NDN335MDHamstra Armen Nofer · Saratoga, CAN356VAVictory Aviation Club Inc · Hamilton, OHN390MSStack Brian James · Paso Robles, CAN3999International Air Service Inc Trustee · Carson City, NVN40NCJones Edward B · Valdese, NCN428SGriffing Flying Service Inc · Port Clinton, OHN42942Mott Plane LLC · Morning Sun, IAN42945Pollnow Dean M · West Bend, WIN4296NScholz Daniel Joseph · Mantorville, MNN4296SB J Air Inc · Wilmington, DEN42985Hall Jason · Iron Mountain, MIN42986Xp Inc · Rehoboth Beach, DEN42993Bc Aviation LLC · Valdosta, GAN4301MHayes Feeding Company LLC · Osceola, NEN4304WGuyton Gregory P · Phoenix, MDN4308DWaterfall Airways LLC · Prospect, KYN4312MRichards Michael Luke · Orlando, FLN4327JDowling Investments LLC · Gillette, WYN4327PKing Air Inc · Naknek, AKN4331BParker Charles B · Fort Myers, FLN43355Calloway Enterprises LLC · Johnson City, TNN4336DWing Flying Club · Lees Summit, MON4339LAnn Arbor Flyers Inc · Ann Arbor, MIN434DJThomason Aviation LLC · Rockford, ILN4364FPwc Hawaii Corp · Lahaina, HIN4370TSnore No More · Wilmington, DEN4371VBrantley Sidney A · Mount Pleasant, SC
Back to Piper PA-32-301