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 ('2072504')
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 ('2072504')
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.
N7950TSchroeder Henry G · Lacombe, LAN7951TClair Brent A · Loraine, ILN7952TGregg John I Jr · Glendale, AZN7959TArrow LLC · Pateros, WAN7960THayden James R · West Fargo, NDN7961TBoardman Thomas M · Greenwich, NYN7963TSawyers Susan J · Tazewell, VAN7967TMachowicz Mark M · Eastpointe, MIN7968TSiegel Donald S · Northampton, MAN7974TByers Theresa L · Freedom, CAN7979TIvy James H III · Seligman, AZN7986THendrickson Robert E Jr · Royal Oaks, CAN7988TBooher David W · Shirleysburg, PAN7992TMoyle Mark S · Fallon, NVN7994TDekryger John P · Fremont, MIN7995TNacarato Justin K · Fort Worth, TXN7998TSirani Chris J · Oasis, IDN7999TPrice Gregory L · Kyle, TXN8000TBas Part Sales LLC · Greeley, CON8002TBierer David E · Victor, MTN8003TAcker Brandon D · Portland, ORN8008TRichardson Ronnie L · East Wenatchee, WAN8011TDykstra Wayne A · Pipestone, MNN8020TVintage Aero LLC · Brownwood, TXN8021TSale Reported · Irvine, CASale reportedN8023TKown Phyllis L · Hamilton, ALN8025TAerial Advertising Services · San Jose, CAN8030THuff Tony D · Luthersville, GAN8032TSchwartz Matthew T · Winfield, WVN8033TWunrow William · Decatur, TXN8039TBay Dustin L · Chico, CAN8049TJasper Ann L · Las Vegas, NVN8050TBeebe Steven J · Traverse City, MIN8051TSkylark Aircraft LLC · El Mirage, AZN8054TAvey Richard D · Klamath Falls, ORN8064TThomas Raymond · Deer Park, WAN8065TDefalco James B · Simi Valley, CAN8070TPerry Edward Glen · Corinne, UTN8071TMccachren Yates M Jr · Harrisburg, NCN8076TJohnson Stephenie I · West Columbia, SCN859ZSeneca Flyers Inc · Waterloo, NYN8882Landiedel Thomas DBA · Spokane, WAN90045Kuzma Steven L · Eugene, ORN973WDBaggenstoss William J · Weiser, IDN992CDPineland Properties LLC · Volga, SD
Back to Cessna 175A