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 ('2072438')
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 ('2072438')
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.
N4978VGeorgeson Troy D · Sheyenne, NDN4979VRobertson Roy E · Marion, IAN4981VWasatch Industries LLC · Ogden, UTN500DZEz Aviation LLC · Orlando, FLFirst renewal noticeN5097RPlymouth Flying Club Inc · Plymouth, NCN5097VCamm Air · Spencer, IAN5098VHarvestowne Aviation LLC · Saint Charles, MON5099VNew Horizon Aviation Inc · Warwick, RIN5100VSmith Gordon J · Manhattan, KSN5102URegistered aircraftN5103UMontana Aircraft Trust Inc Trustee · Bozeman, MTN5114USilverhawk Aviation Academy LLC · Caldwell, IDN5126VSkylark Flight Training LLC · Wilmington, DEN5128BEastman Gregory L · Pueblo, CON5132ULiberty Exploration Inc · Las Vegas, NVN5136UNg Raymond Fong · New York, NYN5140RAshby Artie Dale Jr · Madison, ALN5146VFischer John W · Waukesha, WIN5147UCox Coleman Haynie · Honea Path, SCN5150UMolina Monreal Angel Humberto · Sahuarita, AZN5155UFlying Unicorn LLC · Aurora, ILN5159UPostolnikov Paul V · Graham, WAN5163UValor View Aviation LLC · Midland, TXN5163VKopacz Thomas · Glen Flora, WIN5169VMalcolm Douglas · Shell Beach, CAN5171USummers Jeffrey L · Pekin, INN5176RRight Rudder Flight Training LLC · La Verne, CAN5176VVangorder Donna · Greenwood, ARN5179VFairmont State University · Fairmont, WVN518PUSalim Omar J · Olympia, WAN5192VStippich James A · Panama City, FLN5204VNimier Alexander M · Chatsworth, CAN5208RL & S Flyer LLC · Old Saybrook, CTN5209VHawkbill Aviation LLC · Hudson, NCN5216VDeener Larry C · Lexington, KYN5219URuryk Jonathan D · Pineville, LAFirst renewal noticeN5225UMagic World Ky LLC · Sulphur, KYN522GCCorkins Research LLC · Greenacres, FLN5244VKnucklehead Aviation LLC · Cedar City, UTN5245VMarianas Air Transfer Inc · Saipan, MPN5246UMize Helicipter LLC · Edmond, OKN5248UStephens Robert Z · Missoula, MTN5253UKronauge Frank A · Dayton, OHN5255UFlight Gear Aviation LLC · Pickerington, OHN525JGFlycarolina LLC · Concord, NCN5261UBackus Gary Carl · Chesapeake, VAN5266UN5266u LLC · Brookfield, ILN5271U71 Uniform Corp · The Villages, FLN5280UStrantz Roger J · Denton, TXN5284VMaznicki Frank W · Fort Lauderdale, FL
Back to Cessna 172RG