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.
N46302Jones Lehman M · Claremont, CAN4633QMavis Air LLC · Poway, CAN46360Johnson Bruce W · Portland, ORN4641QFitzsimons Nicholas T · Covington, LAN46493Brown Michael F · Richford, NYN4649QSkyhawk Services LLC · Lake Wales, FLN464DBCloud James G · Camden, MEN4657QSaddle Mountain LLC · Cave Creek, AZN4659QN4659q Corp · Papillion, NEN4664QBartos William F · Concord, OHN46675Adams James W · Sioux Falls, SDN4672QScott Judith M · Spanaway, WAFirst renewal noticeN467QStegner John J · Boonville, MON4692QZulu Aircraft Leasing LLC · Grants Pass, ORN4693QSievert David M · Santa Cruz, CAN470FSCustom Air International LLC · Homestead, FLN471JROrtiz Rivera Jose E · Bayamon, PRN471PRRed Arrow Aviation LLC · Santa Teresa, NMN474AARegistered aircraftN474HAHutch Aviation Inc · Zavalla, TXN477FReu Aviation LLC · Columbia, SCN478TWTumbleweed Leasing Company Inc · Salt Lake City, UTN479CNFlight World Inc · San Juan, PRN479NTFlight World Inc · San Juan, PRN488JWKagey David M · Seabrook, TXN489BCAviation Services Inc · Barre, VTN48JAJahawk Leasing LLC · Sugar Grove, ILN494TMDuke Flight Training LLC · Bonnyman, KYN496HMTalon Air Service Inc · Soldotna, AKN49CGLeading Edge Flight Academy LLC · Bend, ORN49RLMartineau Aircraft Inc · Butte, MTN4SWSalem Airport Authority · Salem, ILN4TAColumbia Aviation Inc · Columbia, TNN5005RBaer Michael E · Wheaton, ILN500GDElizondo Ernesto · Laredo, TXN5013RBarxbar Aviation LLC · Mesa, AZN5017RR&R Leasing LLC · Fargo, NDN50193Folsom Gary A · Marianna, FLN501TSFlying Tigers Flight School LLC · Houston, TXN50208Haus Jesse M · Fort Worth, TXN5020HBorreson Anthony · Mariposa, CAN5020RMigliaccio Jason · Palm Bay, FLN5021HAlamo Flyers LLC · Elmendorf, TXN5021RWax Sally G · Louisville, KYN5023RStern Joseph L · Morrow, OHN5026RSwinney Marty Sherman Trustee · Macomb, OKN5027RVentura Hector E · Vieques, PRN50291Euros Aircraft Leasing LLC · College Station, TXN502TMDraco Flight School Inc · Chino, CAN5033REastern Cincinnati Aviation Inc · Batavia, OH
Back to Cessna 172M