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 ('2072718')
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 ('2072718')
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.
N3466SFoster Garry R · Advance, NCN3469SStory Jerry L · Webster, FLN3475SSmith Reine K IV · Lockhart, TXN3477SN3477s Inc · Dalton Gardens, IDN3479SCook Mark C · Hutto, TXN3481SDorman Richard E · Mesa, WAN3483SHickey Bill J · La Veta, CON3485SThorp Contractors LLC · Vinita, OKN3487SAscent Investments LLC · Kasota, MNN3488SBarbosa Javier · Edinburg, TXN3491SApollo Aviation Inc · Mound, MNFirst renewal noticeN3493SCola William Patrick · Colfax, CAN3494SLadder Livestock Company LLC · Savery, WYN3495S3495s LLC · Prescott, AZN3497SHenry Bruce N · Bloomfield, NMN3498SEnz Vineyards Inc · Hollister, CAN3499SSky'S Mooney LLC · Missoula, MTN36674Brown Kile Executor · Dallas, TXN388LCIshawooa Air LLC · Cody, WYN428BLFlying Money Pit LLC · Des Moines, IAN4620NTownsend David S · Granbury, TXN470XSale Reported · Priest River, IDSale reportedN5087BSchwebach Victoria L · Coronado, CAN55CPCharli Papa LLC · Clovis, NMN600EERieman Sylvia · Newbury Park, CAN6182Olson Gary P · Lanesboro, MNN629CMByrne Thomas J · Cascade, IDN634AHyatt Alex K · Locust Grove, GAN640SLKoonce Gary L · Midland, TXN65KSSauceda Juan B · Austin, TXN6713CClemens Jerry W · Benton, KSN6955VNeu Timothy F · Orlando, FLN69995Hillis Larry Gregory · Pickens, ARN701DZSkydive Fargo Inc · West Fargo, NDFirst renewal noticeN70WHOrtega Ricky J · Amarillo, TXN714TPRutherford Troy L · Clanton, ALN722EELipham William H · Odessa, TXN731RLTrevor Liou · Brush Prairie, WAN7325CPollard Seka A · Huntington, WVN734SGRydalch Carl D · Saint Anthony, IDN73SC73sc Owners Group Inc · Torrance, CAN76WGCooper David J Trustee · San Francisco, CAN772PLSfc-182 LLC · Kansas City, MON779TCChesire Raphael John · Los Lunas, NMN780HN780h LLC · Angola, INN81689Feisthamel Robert R · Mount Vernon, MON826WSaucedo Arnoldo · Midland, TXN8303SSamia Robert B · The Plains, VAN8305SHatley Ralph A · Eagle Creek, ORN8307SKohlitz Jeffery P · Harrison Township, MI
Back to Cessna 182H