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.
N9685VBlue Skies Aviation Of Wisconsin Inc · Pulaski, WIN9686HHope Lapsley G · Blountville, TNN9686QPetter John W · Wallis, TXN9687QBron Chris R · Springfield, ILN9687VCothron Walter A · Angleton, TXN9688QF And W Flyers Inc · Newman, ILN9689QOptic Air LLC · Sioux Center, IAN9690HConner Mark H · Wauna, WAN9690QRobinson Neil A · Madison, WIN9690VAlbrecht William J Jr · Greenville, NCN9691VNewman Philip · Georgetown, TXN9693HClear Creek Aviation LLC · Buffalo, WYN9693QHughes Ronnie D · Cedar Park, TXN9693VRabideau William J III · Stafford Springs, CTN9694HFitch William R · Dubuque, IAN9694QBexbach North America LLC · Reno, NVN9694VHaller Patrick C · York, SCN9695HGoddard Robert J · Haverhill, MAN9696HMirror Image Inc · Belgrade, MTN9697VWestern Edge Aviation LLC · Dickinson, NDN9698HEagle Simulator LLC · Lake Oswego, ORN9698VVermont Flight Academy Inc · South Burlington, VTN9699VPiercy Danille Marie · North Bay Village, FLN969TTSmoketown Flight Center LLC · Smoketown, PAN9700HBrutko Barry J · Lebanon, PAN9700VStencel Lawrence E · Palm Coast, FLN9706QTzafrir Sheffer · Seattle, WAN9706VDagnon Paul A · Apple Valley, MNN9717HBullock Linda A · Shawnee, KSFirst renewal noticeN9717QRosenberger Gregg J · Keller, TXN9717VTco Inc · Stanley, NDN9718HDyer Stacey T · Jensen Beach, FLN9719VCumbie Curtis F · Fayetteville, ARN9720VBoobas John P · Nicholson, GAN9721HFoster Gary P · Anchorage, AKN9722HQuad Cities Aero LLC · Bettendorf, IAN9722VTck Services LLC · Millington, MIN9723HFlying Tigers Flight School LLC · Houston, TXN9725QWings Over Texas Holdings LLC · Denton, TXN9727VDills John H · Ione, WAN972PMNp Aviation Inc · Naguabo, PRN9730VWings Over Texas Holdings LLC · Denton, TXN9731HCreative Strategies Inc · Proctorville, OHN9732HLand & Leave LLC · Helena, MTN9732VSiguaw Robert E · Deming, WAN9733VTyler Ronald J · Martville, NYN9737VAero Equities LLC · Ventura, CAN974CAFranks Gary W · Bolivar, MON9750QPurdy Adrian · Missouri City, TXN9774WAmerican Patrols Inc · Midland, TX
Back to Cessna 172M