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 ('2072420')
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 ('2072420')
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.
N5977RWhitney Nathan B · Falkville, ALN5980RPetes LLC · Pompton Plains, NJN5981RKenney Anthony G · Oviedo, FLN5996ROwens Wilbur · Rch Palos Vrd, CAN5997RVande Sandt Curtis B · Tioga, NDN6000RKreisler Curt A · Plantation, FLN6002RZelner Gregory M · Merritt Island, FLN6004RSeaplanes R Fun Inc · Wilmington, DEN6006RPpb Aviation Management Inc · Wading River, NYN6007RMaster Jacob M · Waddy, KYN6009RCape Aerial Tours DBA · Chatham, MAN6011RElite Fleet Jacksonville LLC · Jacksonville, FLN6014RInspire Wing LLC · Middletown, MDN6015RPetersen Ryan W · Arlington, WAN6016RCosse Harold C · Vacaville, CAN6020RFly For Fun Aircraft LLC · Rockville, MDN6021RBechtold Richard · Broadlands, VAN6022RCunningham Gene Jr · Bristol, VAN6027RHunt Ronald L · Crystal Lake, ILN6029RLamb Stephen R · Myton, UTN6035RWings Over Waxhaw Flying Club Inc · Waxhaw, NCN6036RConte Perry · Stone Harbor, NJN6041RStanley Herb · Morgan City, LAN6042RMetz Jonathan M · Corpus Christi, TXN6043RDelage Enterprises · Dent, MNN6044RLee Brett · Austin, TXN6047RSwanson Brad J · Yakutat, AKN6049RSmith Timothy John · Parkville, MDN6051RSpalding David · Ketchum, IDN6053RBowen Zackary · Dallas, TXN6054RHobbs William A · Cornelius, ORN6056RMission Aviation Training Academy · Arlington, WAN6060RRiviello Taylor · Costa Mesa, CAN6063RGarcia Pinedo Adolfo · Miami, FLN6067RZhu Kevin · Tigard, ORN6070RHodgson E Russell · Nevada City, CAN6074RKray Timothy P · Lincoln, NEN6075RNelsn Hans A · Sergeant Bluff, IAN6076RAdvanced Targeting Solutions LLC · Perkasie, PAN6077RCultra Daniel L · Rochelle, ILN6078ROancea Traian · Oakdale, CAN6081RWatler John L · Brazil, INN6083RHatle Arlen J · Meadow, SDFirst renewal noticeN6084RKdb Flying LLC · Branchville, SCN6087RPalmenteri Winston D · Rhome, TXN6088RPruette Jason · Oakland, CAN6089RLeadbetter Roy A · Georgetown, TXN6090RPaul Rowe Memorial Airport Association Inc · Kahoka, MON6092RBrock Roy C Jr · Pilot Point, TXN6095RWilbanks James R · Clayton, GA
Back to Cessna 172G