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.
N182BNFlyway Blue LLC · Riverview, FLN182BSEubanks James I · Tallahassee, FLN182CBrian Shover · Tabernacle, NJN182CCM P Perry Properties LLC · Fremont, INN182CDWalko Ann-Marie · Westport Island, MEN182CPHui Jason K · Menlo Park, CAN182CSPegg Jeffry A · Bridgeport, TXN182CVSarshad Ramin · Culver City, CAN182DASkylane Air LLC · Florence, MTN182DRChavez Joshua · Andrews, TXN182EAGoedecke Glenn · Vestavia Hills, ALN182EDCaruso Michael V · Brewster, NYN182HMRosebud Aviation LLC · Roscoe, MTN182HPSmith Jody A · Grapevine, TXN182JRegistered aircraftN182JCKaylen Products LLC · Shreveport, LAN182JLAmundson Cranberry Inc · Babcock, WIFirst renewal noticeN182KLost Griz Aerodrome LLC · Vienna, VAN182KBRegistration Pending · Pontotoc, MSRegistration pendingN182LCarter James Nicholas · Aledo, TXN182LBBradford Anthony · Humble, TXN182MMRacine Multisports LLC · Williamsport, MDN182MRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN182NABishop Trent Alan · Fremont, OHN182NRState Of Wisconsin · Madison, WIN182PCPickens County Sheriffs Office · Pickens, SCN182PGAircraft Guaranty Corp Trustee · Oklahoma City, OKN182PWGarcia Jessica Paige · Magnolia, TXN182QTKirkegaard Knud J · Cameron Park, CAN182RGerard Gary A · Litchfield Park, AZN182RBMarkusic Michael L · Burlington, MIN182RCWaddell Randy · The Villages, FLN182RKJet Feeders LLC · Helena, OKN182TGQuimby John S Trustee · Liberty Township, OHN182TJDessau Aviation Inc · Georgetown, TXN182TKAda Forestry Division · Malvern, ARN182TNPotter Timothy E · Murfreesboro, TNN182USPbj Aviation · Portland, TNN182VQDimension Controls Inc · Burr Ridge, ILN182WDurham David · Reno, NVN182WAGardner David S · Los Alamitos, CAN182WBN182wb LLC · Rome, GAN182WEBarr Air Patrol LLC · Mesquite, TXN182WTBlue Aviation LLC · Lake Worth, FLN182WZEmperor Aviation LLC · West Chester, OHN182XTSlattery Donald J · Midland, MIN182YBD & S Mafco LLC · Tilden, TXN184PWCardwell Aubrey Lynn · Spring Branch, TXN187BCCounty Of Butte · Oroville, CAN18SBTroy Motz Construction Inc · Lincolnton, NC
Back to Cessna 182Q