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 ('2072401')
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 ('2072401')
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.
N98510Touch-N-Go Flying Club Inc · Hillsboro, INN985CPCivil Air Patrol Inc · Maxwell Afb, ALN986AVMoore Aviation Inc · Beaver Falls, PAN986BTMoore Aviation Inc · Beaver Falls, PAN986CPCivil Air Patrol Inc · Maxwell Afb, ALN986WUSilverhawk Aviation Academy LLC · Caldwell, IDN987AVMoore Aviation Inc · Beaver Falls, PAN987BCWings Over Texas Holdings LLC · Denton, TXN987CPCivil Air Patrol Inc · Maxwell Afb, ALN9886FMoody Bible Institute Of Chicago · Spokane Valley, WAN988CPCivil Air Patrol Inc · Maxwell Afb, ALN988WUBravo Whiskey Aviation LLC · Louisville, KYN9895FRetro Modern Aviation LLC · Manitou Springs, CON9897FPinnacle Aviation Services Inc · Encinitas, CAN989WUEglin Aero Club · Eglin Afb, FLN9905FNew Horizon Aviation Inc · Warwick, RIN990CPCivil Air Patrol Inc · Maxwell Afb, ALN9918FChristiansen Aviation LLC · Wilmington, DEN992CPCivil Air Patrol Inc · Maxwell Afb, ALN992WWTss Flying Club Inc · Bethesda, MDN9935FKrahe Richard P · Willoughby, OHN993CPCivil Air Patrol Inc · Maxwell Afb, ALN994WWMabry Properties And Holdings LLC · Jonesboro, ARN995CPCivil Air Patrol Inc · Maxwell Afb, ALN995WWMoore Aviation Inc · Beaver Falls, PAN9968FSoutheast Aircraft Leasing LLC · Jacksonville, FLN996CPCivil Air Patrol Inc · Maxwell Afb, ALN996RAN996ra LLC · Palm City, FLN996WWPea-Wayman Flight LLC · Daytona Beach, FLN9978FSloan Jeffrey L · Hopland, CAN997MCAeroventures Flying Club Inc · Lilburn, GAN997RAAtp Aircraft 4 LLC · Wilmington, DEN9981FKcsi Aerial Patrol Inc · Bakersfield, CA
Back to Cessna 172R