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 ('2071818')
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 ('2071818')
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.
N7027SRed Cessna Aviation LLC · West Valley City, UTN7029SWright Flyers LLC · Fayetteville, GAN7030SAcoba Dylan Anthony · Orangevale, CAN7031SBurns Randall A · Rogers, ARN7032STamayo Ernest R · Dripping Springs, TXN7041SMaclean John A · Glenview, ILN7042SNuernberger Howard P · State College, PAN7043SBaughman Jeffrey S · Keller, TXN7045SDiblasi Francis L · Shelton, CTN7047SHaley William R III · Carrollton, GAN7050SGrizzle Jason · Roscoe, TXN7060SDygas Pauel · Pomerene, AZN7061SDirar Farras S E · Sackets Harbor, NYN7062SPrecision Aerospace Corp · Sarasota, FLN7064SCuddington Mark E · Puyallup, WAN7072SEstby Hans P · Hayfield, MNN7074SBoening Bros Dust & Spray Svc · Floresville, TXN7076SHaeg Timothy R · Saint Joseph, MNN7081SGustafson Clayton H · Woodbury, CTN7084SGreer John M Jr · Mercer Island, WAN7085SMatthews Suzanne M · Horseheads, NYN7091SMoyer Alan L · Perkasie, PAN7094SEdwards Thomas · West Richland, WAN7095SSutton Aircraft Salvage LLC · Palmer, AKN7101SCuellar Lauren · Eagle River, AKN7103SHammerstrand John L · Alpine, CAN7104SHelm Richard A · Buckeye, AZN7108SChapman Gary M · Sagle, IDN7112SBridges Robert S · Friendswood, TXN7118SSanders John B DBA · Knoxville, TNN7126SMartin Marty · Summerville, GAN7127SAbraham Curtis L · Byron, WYN7128SHart Brian Jay · San Marcos, TXN7130SHansen Christopher H · Durhamville, NYN7136SGonzalez Alec · Homestead, FLN7138SDeaton Craig · West Alexandria, OHN7144SLet There Be Flight LLC · Portage, MIN7148SJupiter Flight Service And Investing LLC · Lithonia, GAN7149SMcateer Kristy · East Greenwich, RIN7154SAlexander Aviation LLC · Ellisville, MSN7159SSaathoff Michael A · Stockton, MON7162SHensley Aviation LLC · Telford, TNN7164SGardner Terrence L · Pittsboro, NCFirst renewal noticeN7165SCaskey Martin K · Paso Robles, CAN7168SInternational Air Services Inc Trustee · Carson City, NVN7172SLovaas Darryl G Trustee · Crescent City, CAN7174SBelasco Thomas D II · Bridgeport, WVN7177SGambell Jesse D · Mulino, ORFirst renewal noticeN7178SMcclain Matthew S · Yelm, WAN7182SHoward William M · Greensburg, PA
Back to Cessna 150H