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.
N2629FFodness Jan N · Sioux Falls, SDN2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeN2632FOn Final Holdings LLC · West Olive, MIN2633FYork Greg · Blanco, TXN2634FCockerham Milton D · Gooding, IDN2636FCernilia James J · Newport Beach, CAN2637FMccrum James M · Seattle, WAN2639FHendershott Kevin J · Vacaville, CAN2643FWortham Bethany S · Soldotna, AKN2645FMichel John Vernon III · Westminster, MDN2646FAmerican Driveaway LLC · Cowden, ILN2647FGayneaux Kelly J · Midland, TXN2648FLincoln Sport Parachute Club Inc · Lincoln, NEN2649FSkylane 2649f LLC · Kalispell, MTN2650FFlight Time LLC · Highland, MIN2651FMars Aviation LLC · Commerce City, CON2652FMartindale Lloyd M · Bellingham, WAN2653FBagstad Lance · Park Rapids, MNN2654FGregory Daniel · Virginia Beach, VAN2657FPoolshark Equipment LLC · Memphis, TNN2658FClayton Alfred T · Anchorage, AKN2660FWheels Up Aviation Inc · Lewes, DEN2667FVan Hooser Barry S · Pleasanton, CAN2668FBreaux Robert R · Chino Hills, CAN2669FMichelbrink Hunter J · Gardiner, MTN2672FWright James F · Glenford, OHN2675FVarnado Matthew G · Denham Springs, LAN2677FNeu Aviation LLC · Benton, LAN2679FR & K Explorations Inc · Bonners Ferry, IDN2680FWatkins Jeffrey M · Auburn, CAN2684FFelts Anthony E · Groveland, CAN2685FBabovic Slobodan · Elm Grove, WIN2686FKing Cara Jean · Deland, FLN2687FT Air LLC · Columbia Falls, MTN2688FWagosh Aviation LLC · Flagstaff, AZN2690FStephenson Casey H · Assaria, KSN2699FRegistration Pending · Jonesboro, ARRegistration pendingN26LLGmr Leasing LLC · Lincoln, DEN2700FRegistration Pending · Hearne, TXRegistration pendingN2702FLaird Charles L · Adelanto, CAN2704FUltimate Aviation LLC · Philadelphia, PAN2707FMontgomery Robert · Casper, WYN2709FArmentrout Billy W · Thomasville, NCN2714FDdh LLC · Goddard, KSN2715FLow Wings Aviation LLC · Gassville, ARN2718FJackalope Flyers LLC · Whitefish, MTN2719FSjoblom Erik Anders · Washington Twp, MIN2723FTrantham Robert Keith · Alexandria, ALN2724FIsley Rocky · Lacey, WAN2725F85 Charlie Papa LLC · Phoenix, AZ
Back to Cessna 182J