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 ('2072431')
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 ('2072431')
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.
N758NDPlatinum Hawk Xp LLC · Flower Mound, TXN758NFBoeing Employees Flying Association · Renton, WAN758NJNoble Investments LLC · Naples, FLN758NLDc Aero LLC · Ramona, CAN758NVKirk Blackstone LLC · Las Vegas, NVN758NYHall Associates LLC · Homer, AKN758PDWilliams Gary L · Hastings, NEN758PEHeise Jeffrey A · Fishers, INN758PHFarguson David M · Pasadena, CAN758PKSkyking Aviation LLC · Obion, TNN758PNColorado Northwestern Community College · Rangely, CON758PTTkj Equipment LLC · El Dorado Hills, CAN758PVLuck Richard S · Superior, WIN758PXWiley'S Little Red Wagon LLC · Osseo, MNN758PZSt Matthew Aero LLC · Kalispell, MTN758QCMccray B F Jr · Manchester, OKN758QEThomason Land Co · Garden City, TXN758QNCessna 172xp LLC · Wilmington, DEN758QPBarbee Donald L · Columbus, OHN758QVMidwest Aviation Inc · Mayfield, KYN758QX4-Gs Holding Co LLC · Cashmere, WAN758QYRegistration Pending · Arlington, TXRegistration pendingN758QZDovy Aviation LLC · Houston, TXN758RCMattern Todd A · Yuma, AZN758RJWilliams Steven M · Cazenovia, NYN758RLRegistered aircraftN758RNDavis Evan · Haddonfield, NJN758RSStewart Jon L · Walker, MNN758RVLejeune Thad · Eunice, LAN758RXBuss Rhonda K · Hustisford, WIN758SFBauer Walter G · Neenah, WIN758SYMasser Management Inc · Leck Kill, PAN758TAStonehouse William L · Clovis, CAN758TJSilverstein Bradley · Derby, KSN758TKBookout Samantha · Louisville, MSN758TNStevenson Aviation LLC · Harrisville, UTN758TSNiemiec Luke · Assonet, MAN758TTLawson Paul L · Vancouver, WAN758TVReeder Flying Service Inc · Twin Falls, IDN758TXMehn Michael J · Berlin, WIN758TY5 Star Farms · Johnson, KSN758UCL&S Adventure LLC · Rocklin, CAN758UHKobesky Jeffrey · Dunkirk, MDN758VPHorn Jon S · Phoenix, AZN758VSWieden Air LLC · Owasso, OKN758VUParlet Brian C · Banning, CAN758VWSimon Ilene F · San Mateo, CAN758WBFinity Engineering LLC · College Place, WAN758XBLet The Fur Fly · Payson, AZN758XSG & A LLC · Eagle River, AK
Back to Cessna R172K