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 ('2072735')
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 ('2072735')
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.
N4955THayhoe Bruce C Jr · Chippewa Falls, WIN4966SMonkey Butler LLC · Pacifica, CAN4972TPhilema Turf Inc · Americus, GAN4978TRoth Robert A · Pacific Palisades, CAN4980TAdams Aviation Services Inc Trustee · Wilmington, DEN4PLumsdaine Christopher G · Lompoc, CAN502TVShyena Aviation LLC · Henderson, NVN5036RArctic Winds Inc · King Salmon, AKN5041RBdc Products Inc · Glendale, AZN5076RStable Approach Aviation LLC · Vestavia, ALN5083CTsf Inc · Bristol, WIN5087SKartchner Stanley J · Tucson, AZN5091SLancellotti Peter · Knoxville, TNN5091TBlank Philip J · Pleasanton, CAN5106SDawson Michael · Lynnwood, WAN5117TLevitan Sergei · Hollywood, FLN5125TAdflight Inc · Lafayette, LAN5141SChamberlin George W · Greenville, TXN5146SBowden Mark R · Kansas City, MON5153RVogel Todd J · Bishop, CAN5154TCatalpa Lane Aviation LLC · Raymond, OHN5191SBomar Christopher P · Munford, TNN5193TDersahakian Harmik · Porter Ranch, CAN5196RRise Aviation LLC · Jackson, WYN5196SPasos Viviana Vivian · Tucson, AZN51FRRegistered aircraftN5204SHildahl Gene G · Chelan, WAN5241TWeiss Gregory K · Colorado Springs, CON5251THubka Charles A · Beatrice, NEN5257SSchumaker Grant E · Wichita, KSN5260TJordan David E · Saint Helena, CAN5270SMe & Cl Holdings Inc · Harlingen, TXN5271SRegistered aircraftN5275RNorth Matthew E · Oro Valley, AZN5276SParke Travis · Rancho Cucamonga, CAN5289TEaves Jeffrey L · Wichita Falls, TXN5303SKillpack Kevin R · Rio Rancho, NMN5304SWindward Air LLC · Janesville, WIN5316SDk Air LLC · Brookings, ORN5317TCovert Charles F · The Dalles, ORN5343SRayham LLC · Oxford, GAN5359SRegistered aircraftN5362TLipscomb Rik · Wichita Falls, TXN5377SHicks James S & Hicks Sally J Edgar Trustee · Oregon City, ORN5379SStevens Michael J Trustee · Park City, UTN5384SFischer Dale L · Glyndon, MNN541BSDalke Debbie R · Aumsville, ORN5447TWalkington Noel John · Pittsburgh, PAN5453TSale Reported · WeidenSale reportedN5461SCarter Kenneth M Jr · Castle Rock, CO
Back to Cessna TR182