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 ('2072724')
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 ('2072724')
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.
N2626QTomasini William M · Boring, ORN2626R2626r LLC · Tucson, AZN2627RTaylor John B · Norwich, OHN2628QSannikova Olga · Sherman Oaks, CAN2629QStallings Floyd P · Vine Grove, KYN2630QParrington Robert · Rifle, CON2630RBurdine Kenneth L · Newland, NCN2631QManning Brian A · Malvern, IAN2633RDevries Mark R · Eagle River, AKN2635RJong Hoon Cho · Rch Palos Vrd, CAN2641RHowatt Scott · Hannah, NDN2643QOst Jesse E · Hunter, KSN2643RNorthern Wings LLC · Spokane, WAN2644RColler Randy L · Jackson, MIN2647RSaber Wings LLC · Sacramento, CAN2648QBuck Irrigation Inc · Elkhart, KSN2649RShah Aitazaz · Shady Shores, TXN2652RDevries Francis P · Justin, TXN2653QMoses And Associates Inc · Gainesville, FLN2654RFindarle John J · Midway, UTN2655QRedmond Angela L · Austin, TXN2655RBeck Bartholomew · Dry Ridge, KYN2656QPankrate Kenneth W · Opheim, MTN2656REdex Aviation LLC · Sutter Creek, CAN2658RNorthern Science Services LLC · Anchorage, AKN2659QMorrison Mark C · Marfa, TXN2659RBerrios Antonio · Genoa, ILN2660RPa Bo Ma Inc · Alexandria, LAN2661QAlred Robert I · Barrow, AKN2663QBerg Weston L · Stanton, NDN2666QCloos Randy J · Osburne, IDN2667RJorgensen Larry C · Randle, WAN2668RCummings Robert S · Bowling Green, KYN2669QBanks Ron E · Blanchard, OKN2669RStrubhar Wesley D · Foster, ORN2671RCw Equipment Rentals Inc · Biggs, CAN2673RDouville Laura Deluea · Portland, ORN2679RSchultz Charles D · Webster, WIN2682RRadeka Michael · East Machias, MEN2683RNance James H II · Grants Pass, ORN2684QJastram Benjamin C · Lafayette, LAN2685QMcelmoyl John W · Greenfield, CAN2686QLines Daniel R · Roseburg, ORN2687QKnorr John Lee · Puposky, MNN2687RSpangler Keith · Monroeville, INN2688RShaw Thomas B · Hobbs, NMN2689QKirschke John K · Seneca Falls, NYN2689RMortensen Mark S · Hamilton, MTN2690RSchleck Scott A · West Concord, MNN2691QEw Aircraft LLC · Manhattan, MT
Back to Cessna 182K