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 ('2072418')
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 ('2072418')
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.
N7777CSouthern Sky LLC · Henderson, NVN777AHJarhead Aviation LLC · Port Saint Lucie, FLN779PTMacon Air LLC · Franklin, NCN782SNKingdom Air Corps · Sutton, AKN785ASA S Flight Academy LLC · Lantana, FLN786JHButler Carol J · Anchorage, AKFirst renewal noticeN789RAMiller Melanie L · Spanaway, WAN793PTCappe Investment Group LLC · Homestead, FLN796EPPrince Ellis C · Frierson, LAN7AFN7af LLC · Ronkonkoma, NYN7LPFirth Leonard F · Navasota, TXN7XYHewett Nancy A · Tacoma, WAN80079Ramos Anthony K · Fresno, CAN80087Kazmer Gary W · North Windham, CTN80088Wolgat Alexander · White Lake, MIN80090Cloud Hoppers II LLC · Chicago, ILN80092Bronco Flying Service · Coldwater, MIN80094Hartshorn Michael P · Danville, ILN80095Ivy James E · Alba, TXN80097Yates Gregory A · Murrayville, ILN80102Transonic LLC · Wilmington, DEN80105Heilmann Charles E · Millwood, WVN80106American Patrols Inc · Midland, TXN80112Lind Enterprises LLC · Manistee, MIN80116Laingkids LLC · Lewes, DEN80117Valley Fliers Flying Club · Auburn, WAN80118Skylens LLC · Hammond, LAN80119Wellman David H · Eugene, ORN80121Sky Gypsies LLC · Lansdale, PAN80123Fremont Aviation Inc · Fremont, NEN80127J C Dalco Inc · Westminster, CAN80128Gonzalez William I · Babylon, NYN80129Potter Raymond C · Torrey, UTN80130Harrison W Henry · Philadelphia, PAN80131Riverside Pilots Inc · Riverside, CAN80135Adventure North Flying Service Inc · Aitkin, MNN80137Walla Walla University · College Place, WAN80149Cielos Serenos LLC · Tucson, AZN80154Aircraft Guaranty Corp Trustee · Oklahoma City, OKN80158Anderson Paul M · Brandon, MNN80159Iowa Lakes Community College · Estherville, IAN80160D S Swain Gas Co Inc · Washington, NCN80164Bogacz Frank · Sarver, PAN80165Hodgkins John L III · Lake George, NYN80168Stratus Aviation LLC DBA · Vacaville, CAN80173Air Athens LLC · Athens, GAN80181Vero Technical Support Inc · Pensacola, FLN80182Ranson Allan W · Hot Springs, ARN80183Northland Aviation LLC · Manitowoc, WIN80184Ljmf LLC · Hays, KS
Back to Cessna 172M