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 ('2072732')
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 ('2072732')
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.
N282EL282el LLC · Pendleton, ORN282JPMarshalls Sanitation Services LLC DBA · Fallon, NVN282TWLake Of The Woods Aviation LLC · Baudette, MNN288RWNortheastern Assets Holdings LLC · Dover, NHN2911DPagano Ralph V · Cranbury, NJN29PCFisher Douglas C · Mountain View, CAN2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeN2JKGoldberg Leonard J · Westbrook, CTN2XNDudebuddy Aviation LLC · Kalispell, MTN300TDContinental Aerospace Technologies Inc · Mobile, ALN303BSLegacy Restoration Services Inc · Cumming, GAN304DB4db Leasing LLC · Englewood, CON30CTLaidley Robert F · Erie, CON318DMDelta Kilo Mike LLC · Rayville, LAN31YBProgressive Air Inc · Janesville, WIN321BSBrown Gregory N Trustee · Flagstaff, AZN321KKPanoche Aviation Co LLC · Fresno, CAN321PPMathews Aviation LLC · Marysville, CAN321RZRieger Joseph M · Ashland, ORN321WHBonanza Equipment Leasing LLC · Missoula, MTN32282Watson Scott E · Wichita, KSN322WRBabineaux Kenneth W · Porter, TXN324RHPhillips William L Trustee · E Hampton, MAN327HRRd Holdings LLC · Las Vegas, NVN327LSHeermann Philip D · Albuquerque, NMN32CWMcdiarmid Jeffrey · Walla Walla, WAN32PLDiette Paul S · Middlebury, VTN32TCarolina Blue Aviation LLC · Villanova, PAN32ZZJp Lemke Aviation LLC · Jenison, MIN333ZVWalker Wilber D III · Beeville, TXN338BMMorton William · Darby, MTN339CHPitch And Power LLC · Indianapolis, INN33KRAviaschin LLC · Frisco, TXN33MLDaedalean Inc · Chandler, AZN33NRLuis Antonio · Miami Springs, FLN33VGTexter Mountain LLC · Reinholds, PAN342MWHolway Stephen M · Gainesville, FLN348ABBledsoe Alvin · Horseshoe Bay, TXN353DWZephyr Aviation LLC · Greenwood Village, CON35XTWrench John D · Los Olivos, CAN364CMoore Charles K · Woodinville, WAN369CBHahn Mitchell S · Chagrin Falls, OHN369MBBarnes Matthew L · Pacific Palisades, CAN36NHAlgar Linda · Tucson, AZN36XCHangar C-403 LLC · Walnut Creek, CAN377HChupp Jeffrey L · Grove City, MNN387WYSvp LLC · Missoula, MTN38RZGgt Aviation LLC · Saint Paul, MNN399HLon Air LLC · Miles City, MTN399KOsborn Ferrell V · Avery Island, LA
Back to Cessna 182Q