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 ('2072434')
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 ('2072434')
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.
N75633Dauphinee Kevin Carl · Bingham, MEN75635Sarge Aviation LLC · Brazoria, TXN75643Pecoraro Michael J · Gloucester, MAN75649New Horizons Aviation Inc · Goshen, INN7564ETama Aviation LLC · Ludington, MIN75651Hansen Robert Alan · Horseheads, NYN75655Doane Dale A · Moreland, GAN7565DSiegle Daniel L · Birdsboro, PAN756AWLincoln Skyways Inc · Lincoln, CAN75701Roseville Aviation LLC · Roxboro, NCN75704Lanning 1 Aviation LLC · Amarillo, TXN75706Morey Airplane Company Inc · Middleton, WIN75709Newsom Richard W · East Bend, NCN75710Cox Leon F · Ruffin, NCN75711Falcon Air LLC · Anchorage, AKN75712Hill David Ryan · Palm City, FLN75714Lincoln Skyways Inc · Lincoln, CAN75716West Bend Air Inc · West Bend, WIN7571EHaack John L Trustee · Dunedin, FLN75721Propell Air LLC · Deridder, LAN75722Pt Real Estate Inc · Port Hadlock, WAN75724Lenamond L Don Jr · Anchorage, AKN75726Don Davis Aviation Inc · Henderson, KYN75731Ziegler Carl F · Forest Lake, MNN75733Red Door Aviation LLC · Dover, DEN75739Entroair LLC · Hilliard, OHN75740Kingdom Air Corps · Sutton, AKN75743Aerosmith Aviation LLC · Panama City Beach, FLN75744Blue River Aviation LLC · Palmer, AKN75746C-Squared Aviation LLC · Delaware, OHN75748Porter Steven C · White Rock, NMN75749Mckinstry Adam V · Hubbardston, MIN75754Welch Gregory A · Atlanta, GAN75759Eda Of South Carolina LLC · Greenville, SCN75762208 Aviation LLC · Richmond, VAN75770Griffin Robert L Jr · Washington, NCN75771Ludwig Raymond K · Scottsdale, AZN75774Seyboth Jason R · Harvest, ALN75775Rocky Mountain Aircraft Services LLC · Broomfield, CON75776Frix Richard D · Bluffdale, UTN75778Lima-001 LLC · Muscatine, IAN75786Bienvenu Reuben S · Lafayette, LAN75788Hawk Air LLC · Parma, OHN75790Kempton Larry G · Grand Junction, CON75791D L S Aviation Services Inc · Wilmington, DEN75793Miami Valley Career Technology Center · Clayton, OHN75794Appleton Scott · Cunningham, TNFirst renewal noticeN75795Harrison Mark A · Corpus Christi, TXN75797Eralet Inc · Middletown, DEN75799Ocean Breeze Aviation Inc · Hollywood, FL
Back to Cessna 172N