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 ('2072722')
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 ('2072722')
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.
N2850FGozansky Elliott K · Birmingham, ALN2852FLane Jeffrey A Trustee · Elm Grove, WIN2857FGarcia Gregory · Sacramento, CAN2858FFlying Fur LLC · Huntsville, ALN2859FValley City Flying Club Llp · Valley City, NDN2860FSullivan Stanley D · South Jordan, UTN2861FProair LLC · Dayton, IDN2862FFoxtrot Partners LLC · West Bountiful, UTN2863FWright William J · Raeford, NCN2864FPreszler Sharon J · Mesa, AZN2865FMctaggart Briar · Oroville, CAN2866FHowell Thomas F · Red Bluff, CAN2868FBrown Isabelle R · Bay Shore, NYN2876FJohnston Natalie R · Edgewood, TXN2879FMinich Sophie R · Anchorage, AKN2884FTurner Michael B · Covington, TNN2886FWeldon Larry W · Titusville, PAN2888FLynch Neil E · Ceresco, MIN2889FLander Kirt E · Kingman, AZN2890FAeolus Aviation LLC · Franklin, TNN2891FBayshore Properties LLC · Hagerstown, MDN2892FSpeedtape Airways LLC · Williamson, GAN2895FWilson Paul D · Peachtree Corners, GAN2896FEvans Gene · Center, MON2897FDeeck Mechanical Inc · Albemarle, NCN2899FWashburn Michael D · Farmington, UTN2900FSciathan LLC · Grosse Pointe, MIN2903FSawyers Ricky Dean · Tazewell, VAN2908FCooprider Lee W Trustee · Littleton, MAN2911FRegistration Pending · Fayetteville, ARRegistration pendingN2914FHarris Zadok · Upland, CAN2915FStoffregen Thomas S · Milton, WVN2916FAndros Marketing LLC · Fort Lauderdale, FLN2917FBennett David D · Clinton, WAN2919FPerez Adolfo · Conroe, TXN2922FKalil Joseph J Jr · Morgan, UTN2924FReese Howard Aviation LLC · Anderson, SCN2925FRegistered aircraftAssigned, pending cancellationN2929FSmith Lane R · Lewistown, MTN2930FWrucke Scott · Horicon, WIN2933FLevinsohn Reuben D · East Lansing, MIN2934FH & S Aviation LLC · Roseville, MNN2935FPeirce Brenden D · Eatonville, WAN2939FGeorges Aerial Spraying Service Inc · Sutton, NEN2940FHarry Daye Aviation Services LLC · Surprise, AZN2942FSdc Aviation LLC · Fort Smith, ARN2944FJ3 Contracting Inc · Milton Freewater, ORN2947FCopeland Matthew S · Wichita, KSN2950FSpring Ronald L · London, OHN2951FHarvey Thomas R · Jacksonville, FL
Back to Cessna 182J