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 ('2072424')
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 ('2072424')
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.
N497RAMartin Anthony M · Beebe, ARN4981RUnited States Air Force (Owner) · Offutt Afb, NEN4983RAmerican Flight Museum · Topeka, KSN4985RUnited States Air Force Owner · Clovis, NMN4987RUnited States Air Force Owner · Offutt Afb, NEN4989RLansing Community College · Mason, MIN4990RSmith Joshua B · Kenai, AKN5107FFly Idaho LLC · Meridian, IDN5333TParkison Leland Cameron · Battle Ground, WAN5615GShaw Miles · Wasilla, AKN563RSRaven Bryan F · Lakeland, FLN581CGLoveless Jacob L · Carlinville, ILN595TSArner Michael D · Tolland, CTN5FBRichers David M · Thornton, CON600JFAerial Scouting Solutions LLC · Sioux Center, IAN6261QPitz William A · Mitchell, SDN6302FForrest Steven L · Wrangell, AKN67RVHopman Richard G · Oxford, MIN680JFDunham Transport Inc · Wannaska, MNN70DKParmley Terry R · Michigan City, INN73TFKlanchar Flying LLC · Benton, ARN75EAero Techniques Inc · Portage, MIN7CWDalton Christopher J · Vlg Of Lakewd, ILN8001LHoupt David · Clinton, OHN8003LCrump Shawn C · Gonzales, LAN8006LGmdg LLC · Shreveport, LAN8010LLegion Flying Club Inc · Springfield, MAN8011LLaska Lonny J · Tonawanda, NYN8013LCarroll Connie S · Clyde, TXN8017LOgle Randall W · Wenatchee, WAN8019LSleeping Giant Flying Club Inc · Helena, MTN8026LSayers Carl D · Vidalia, LAN8027LVan Kirk Malcolm R · Frederick, MDN8029LBeasley Marvin T · Vidalia, GAN8030LScala Anthony J · New Hyde Park, NYN8032LCorbin Air Inc · Saint Clair Shores, MIN8037LSkyglide LLC · St George, UTN8044LOverton Larry D · Hermiston, ORN8045LAmonett Rodney · Abilene, TXN8048LFour Dudes And A Plane LLC · Whitehouse, OHN8049LPrewitt Murray L · Lake Jackson, TXN8050LRobinette William B · Youngstown, OHN8053LSasser Jeremiah · Ceres, CAN8054LAdams Clint D · San Antonio, TXN8055LRowden Paul G · Wichita, KSN8056LJenkins Mark · Santa Clarita, CAN8057LSale Reported · Kirksville, MOSale reportedN8060LOneonone Flight Training LLC · Hagerstown, MDN8061LColeman Terrence C · Maryville, TNN8064LMccormick Michael P · Durham, NC
Back to Cessna 172H