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 ('2071816')
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 ('2071816')
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.
N495RAGabbard Derek L · Paint Lick, KYN499WTHagenbrock Scott L · Celina, TXN4JRN4jr LLC · Columbus, MSN5117G5117g LLC · Sandy, ORN512ADDiffenderfer Andy C · Horseheads, NYN551CTWaud James L · Hubbard, ORN5582HHendrickson Justin N · Richmond, INN560MAKrauss Solutions LLC · Debary, FLN5622Nichols Stephen S · Hartland, WIN563FSPatterson Marshall S · Tuscumbia, ALN564DSLopez John · Prole, IAN5680PHaro Roger E · Eden Prairie, MNN5JPWard Russell S · Kingman, AZN6010AHolley William E · Kilgore, TXN6200SKnick Michael J · Camarillo, CAN6204SRed Baron Flying Club Inc · Pleasant Ridge, MIN6205SFriesen Valry C · Ryder, NDN6206SSluyter Zachary W · Greeley, CON6214SRex Douglas A · Marion, INN6215SSmith Clifford W III · Exeter, CAN6216STms Holdings LLC · Neenah, WIN6217SKent J'Amy L · Chewelah, WAN6223SKlingele Beth A · Wapato, WAN6228SYoder Edwin A Jr · Concord, GAN6230SMelnyk Oleg · Willoughby Hills, OHN6233S33sierra LLC · Soldotna, AKN6234SCorbin M Stuller · Yoder, INN6235SRudnik Zachary A · Minto, NDN6243SBlackwood Heath · Meridian, IDN6249SPurawic Jessica · Asheville, NCN6253SShroyer Rex G · Philomath, ORN6257SHoffmeyer Scott D · Carson City, NVN6259SDavis Scott B · Quincy, ILN6260SBrowne Clifford B · Southport, MEN6261SWinnewisser Steve G · Santa Barbara, CAN6262SSamis Kyle C · Emeryville, CAN6264SJohnson Eric C · Turtle Lake, NDN6265SWilson Daniel · Bandon, ORN6266Wheaton Eric J · Gig Harbor, WAN6268SHayes Barrett W · Siler City, NCN6270SHudson Kelly G · Monroe, NCN6271SJay Square Aircraft Inc · Hilton Head Island, SCN6277SJones Joseph L · Saint David, AZN6282SWorth William D · Huntington Beach, CAN6283SMorris Kristina T · Ventura, CAN6285SWindsor John R · East New Market, MDN6286SCunningham Doris DBA · East Freetown, MAN6289SLink Darryl B · Centennial, CON6290SFloyd Brannon A · Athens, GAN6292SAviation Trust Company LLC Trustee · Oklahoma City, OK
Back to Cessna 150G