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.
N9538HK & L Air Inc · Brazil, INN9542HAbusham Hamed M · Upland, CAN9543HGonzalez-Rio Jesus A · Big Pine Key, FLN9544HSouthern Aero LLC · Homestead, FLN9546HMiller Dale L · Bozeman, MTN9549HBenson Edward A · San Antonio, TXN954JHWings Over Texas LLC · Denton, TXN9552HZulu Aircraft Leasing LLC · Grants Pass, ORN9552VRico Aviation Services Inc · Miami, FLN9554VCavu LLC · Fort Collins, CON9555HWilkinson William · Anchorage, AKN9556VMiles James D · Memphis, TNN9557VSkyhawk 57v Inc · Pittsburgh, PAN955LCSewell Michael D DBA · Russellville, ALN955PTCappe Investment Group LLC · Homestead, FLN9560VRegistration Pending · Big Spring, TXRegistration pendingN9562HL & W Aircraft Investments LLC · Homestead, FLN9562VWinged Winds LLC · Douglassville, PAN9564HLafleur Laurence J · Natick, MAN9566HGarcia Mario · Yuma, AZN9566VS D Enterprises Ltd · Brookhaven, NYN9567HCurley Mark L · Alamosa, CON9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationN9568VAnderson Zachery D · Bigfork, MTN9569HOsborn Larry R · Summerville, SCN9571HWings Over Texas Holdings LLC · Denton, TXN9571VTempleton John E · Loami, ILN9572HGeneral Aviation LLC · Henderson, NVN9572VHill Timothy E · Hooks, TXN9573VReynolds Darryl G · Wills Point, TXN9574HJb III LLC · Stuart, FLN9575VFurnari Alfio · Hutchinson Island, FLN9577VMdr Flying Inc Trustee · Wilmington, DEN9582HMiller Timothy · Saratoga, CAN9582VCady Craig D · New Braunfels, TXN9584VStick & Rudder Club Inc · Waukegan, ILN9585VHarrington Aviation LLC · Scarborough, MEN9587VPinnick Brent E · West Baden Springs, INN9588VKachemak Bay Flying Service Inc · Temple, TXN9589HFryar Scott D · Starke, FLN9593HSaliba Bahig Nadim · Scottsdale, AZN9593VWeaver Robert D · Petersburg, WVN9594HEagle Sky Patrol Inc · Deadwood, SDN9596HCorby Brenda K · Oak View, CAN9597VSkelton Jeffrey · Sioux Falls, SDN9598HImsar LLC · Springville, UTN959HCNorthwest Wings LLC · Hillsboro, ORN95CPGates Thomas S · Moyock, NCN9601QSteel Aviation Inc · Walnut Cove, NCN9603QConnecticut Flyers Inc · Madison, CT
Back to Cessna 172M