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 ('2071826')
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 ('2071826')
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.
N5452QRhein Craig · Mastic, NYN5454QPetko James · Mishawaka, INN5459QZimmerman Dean F · Royalton, MNN5460QJacobson Eric R · Ouray, CON5464QBinsfeld Thomas · Chico, CAN5465QWhitford John T · South Weber, UTN5466QDe Sciscio Salvatore A · Chaplin, CTN5470QBuiqui Aerospace Corp · Kissimmee, FLNon-citizen corporation, flight hours not reportedN5471QGunnarsson Jon · Concrete, WAN5472QAmf Diversified LLC · Mesa, AZN5473QBell Craig S · Warren, OHN5475QParker Jerry F · Mary Esther, FLN5480QNeuman Allen D · Sanger, TXN5481QSmith Glen D · Columbia, TNN5486QAlmeida Donald J · E Bridgewater, MAN5487QEaton Roger C · Vernon, NYN5489QSmith Gregory · Athens, GAN548PUBerkey Aviation LLC · Lafayette, INN5492QMarchant Colby Z · Hazlehurst, GAN5496QPhillips Michael · Bossier City, LAN5498QAtlanta Technical College · Atlanta, GAN552RAGuzman Jose D · Arecibo, PRN557SHUnited States Air Force · Usaf Academy, CON567GSFlying R LLC · Spokane Valley, WAN569GSTwin Cities Flight Training Inc · Blaine, MNN5828RBismark Public Schools · Bismarck, NDN5867CGunnarsson Jon · Concrete, WAN592HPAeroquest LLC · Olive Branch, MSN5BNMountain Air Inc · Quincy, CAN6064JTreger Mark · Dallas, TXFirst renewal noticeN6079JSmith Richard D II · Luthersville, GAN6094JHyten Mark B · Zionsville, INN6095JWaterman David K · Temple City, CAN611KHWolf Ronald T · Abbeville, LAN621APEast Moriches Aerial Ads Ltd · Ridge, NYN621MRElliott Michael R · Friendswood, TXN62853Willkomm John C · Kenosha, WIN62CGJain Ashish K · Hamilton, GAN6383HWest Brian L · Creston, IAN6504GHoward David D · Winner, SDN6505GStern Scot G · Escondido, CAN6512GParry Anthony D · Sedro Woolley, WAN6515GNorthwest Aeroventures LLC · Steilacoom, WAN6521GKirk James H III · Odessa, FLN6523GLee Jay S · Granite Bay, CAN6524GSantana Eric · Lehigh Acres, FLN6531GGalavis Eduardo · Miami, FLN6536GMessersmith Brian W · Grand Prairie, TXN6537GShettel Jay E · Boiling Springs, PAN6539GSchneider Joel · Champaign, IL
Back to Cessna 150L