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 ('2072434')
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 ('2072434')
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.
N6591EWay Robert Louis · Morristown, AZN6595G95 Golf Inc · Greenwood, INN6596DMcdonald Kevin K · Anchorage, AKN6599DBlue Shield Aviation LLC · Saint Petersburg, FLN65GVDemski Domenic Ross · Woodbridge, CAN65JAJahawk Leasing LLC · Sugar Grove, ILN6602DLand Of Liberty LLC · Seminole, FLN6604EFlyn High Aviation LLC · Boynton Beach, FLN6605DAlameda Aero Club · Alameda, CAN6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingN6607DVero Technical Support Inc · Pensacola, FLN6608DAmericus Flying Club Inc · Americus, GAN6609DCopperhead Environmental Consulting Inc · Paint Lick, KYN6611DMoralli Joseph · Chico, CAN6615DCivil Air Patrol Inc · Montgomery, ALN6616DMjng Investment Group LLC · Melbourne, FLN6617ELinstad Daniel Elmer · Canby, ORN6617JJeffries Holdings LLC · Bargersville, INN6618DStein Air LLC · New Ringgold, PAN6619DBannwart Justin S · North Liberty, INN6620DPacific Fleet Aviation LLC · Rochester, NYN6621DCosta Air Service LLC · Painted Post, NYN6622DArq Aviation LLC · Wilmington, NCN6624GBob Hoover Academy · Salinas, CAN665GAFlight Club 502 Inc · Louisville, KYN6665GPurdue Aviation LLC · West Lafayette, INN6694EThunderbird Aviation LLC · Littleton, CON66AALift Aviation LLC · Kingston, MAN66PArchangel One LLC · Lewes, DEN66PRPeterjohn Management II LLC · Pound Ridge, NYN6704EWings Over Texas Holdings LLC · Denton, TXN6717EDenrow Limited Lc · Shawnee, OKN672FCBlackhawk Holding Corp · Wilmington, DEN6778EFriendly Skies Aircraft Leasing LLC · Sacramento, CAN6794EWalls Jerry L · Hawley, TXN6796EBlain Kyra · Conroe, TXFirst renewal noticeN6797EJoe Bob Nelson · Chickasha, OKN6806ELeeper Ramon J · Albuquerque, NMN68460Registration Pending · Sheridan, WYRegistration pendingN6851ECharlie Lima 1 LLC · Jacksonville, FLN686DBAnderson Bruce Robert · Mena, ARN68BDBuiqui Aerospace Corp · Kissimmee, FLN6944EHinds Archie L · Claremore, OKN701BPWings Over Texas Holdings LLC · Denton, TXN701PYVallala Dino D · Milton, WAN706DEBradley Aircraft Company LLC · Columbus, INN7073KCopper River Airmotive LLC · Copper Center, AKN707ATSpacely Space Sprockets LLC · Aurora, ORN708TEAileron Aviation Inc · Cookeville, TNN70TASixty Three Charlie Zulu Inc · Thonotosassa, FL
Back to Cessna 172N