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 ('2072418')
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 ('2072418')
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.
N80371N80371 LLC · Lovell, WYN80372Nelson Bruce · Lutz, FLN80376Aerial Specialties Inc · Decatur, TXN80377Seagull Flying Club Inc · San Jose, CAN80379Early Kevin S · Oregonia, OHN80380Skywarrior Flight Training Inc · Pensacola, FLN80382Sorce Sal · Clark, NJN80389J F Aviation Inc · Joliet, ILN80396Osprey Holding Company LLC · Foley, ALN80414Garn Darrell L · Palmetto, GAN80419Korona Lawrence K · West Paterson, NJN80421Kuder Kyp E · Rogers, NDN80425Fellows Roy H · Augusta, KSN8042FFlying Hawks Inc · Palmyra, WIN80436N80436 LLC · Columbia, MSN80439Oklahoma State University · Stillwater, OKN80440Rockey John · Jupiter, FLN80442Washburne Seth P · Dallas, TXN80454Tadao LLC · Tucson, AZN80456Barash Geva S · Ashland, MAN80458Kolpack Glenn H · Sonora, CAN80469Hetherly Bryce D · Clintondale, NYN80470Coddiwomple LLC · Newberg, ORN80471Dairy Air Inc · Wyoming, PAN80472Simons George Trustee · Bouse, AZN80475Texas Southern University · Houston, TXN80476Sky Roamers LLC · Columbus, NEN80483Harrell Matthew J · Grand Haven, MIN80484Mor Aviation 172m LLC · Gaithersburg, MDN80486Romoser Carey E · Simpsonville, SCN80487Williams Fredrick Glen · Auburn, ALN80489P & K Aviation LLC · Neshkoro, WIN80490American Patrols Inc · Midland, TXN80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIN80495Space Coast Aero LLC · Melbourne, FLN80496Bickel Gregory A · Mckinleyville, CAN80497Ducksrus LLC · Indianapolis, INN804BD G Leasing LLC · Houston, TXN80507High Flight Academy LLC · Allison Park, PAN80511American Patrols Inc · Midland, TXN80517Powers Tia Nichole · Griffin, GAN80519Donald Ben B II · Carthage, TXN80522Mikhael Hanna M · Livonia, MIN80525Dunkin Aviation LLC · Hensley, ARN80526Stoddard County Flyers Inc · Dexter, MON80531R N R Aviation LLC · Malaga, WAN80533Euroaviation Inc Trustee · KematenN80534Millionair Inc · Ferndale, WAN80535Aerial Specailties Inc · Decatur, TXN80536Fremont Flight Academy LLC · Fremont, OH
Back to Cessna 172M