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 ('2071818')
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 ('2071818')
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.
N50299Wood Thomas J · Overland Park, KSN50304Reuben Abraham · Flushing, NYN50308Villano Frank P · Wappingers Falls, NYN50310Richards Lyle · San Diego, CAN50311Khamo Josef · Running Springs, CAN50316Foster Reynolds Sw · Winona, MNN50318Florida Fast Boats LLC · Palm Coast, FLN50323Got Valentin L · Olivehurst, CAFirst renewal noticeN50326Thompson Arthur W · Paris, TXN50328Neiger Steven · Ocean View, NJN50331Sale Reported · Nashotah, WISale reportedN50335Joung Kweon · Cumming, GAN50337Nava Alfred Joseph II · Gig Harbor, WAN50345Stanley345 LLC · Esko, MNN50347Garrett Dennis R · Hudson, FLN50354N50354 LLC · Key West, FLN50355Kurpgeweit William E · Ewing, NEN50356Meyers Meade M · Rockwood, PAN50367American Sky Aviation LLC · Anna, TXN50368Rogers Warren R · Manti, UTN50375Mcburney Cleland V · Kingman, KSN50379Grosdidier Rolland J · Kenai, AKN50382Eastside Aero Inc · Eatonville, WAN50390Dillard Clayton B · Talkeetna, AKN503TCForetich Joseph J · Baker, LAN50400Bostick Alva D H · Portsmouth, OHN50403Reis Gavin · Conway, SCN50404Mcflight Aviation LLC · Highland, UTN50405Und Aerospace Foundation · Grand Forks, NDN50406Aeroplanes Over Idaho Inc · Carson City, NVN50407Coombs Kevin A · Knoxville, TNN50413Rafi Adnan · Olean, NYN50418Forrest City Aircraft Club · Rockton, ILN50419Hamilton Richard Paul · Laredo, TXN50421Franco Gary R · Chico, CAN50425Keneston Mark G · Ballston Spa, NYN50431Board Susan W · Moundsville, WVN50432Mountain Air Flying Club Inc · Clarksburg, WVN50434Summerville Daniel · Millersville, MDN50438Roche Thomas A · Bardstown, KYN50PTJackson Michael W · Bedford, TXN563GMarsh Matthew · Cleveland, ALN564GHughes Ramzi S · Alamo, NVN570UABohl Howard M · Temecula, CAN578MAByte Networking LLC · Juneau, AKFirst renewal noticeN579MAJones Andrew W · Turner, MTN58BWarnick Ronald S · Cascade, MTN5944GYakich Adam J · Fairfield, IAN6409XValdes Omar F · Huntington Park, CAN6410SSaunders Aviation LLC · Roanoke, TX
Back to Cessna 150H