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 ('2072706')
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 ('2072706')
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.
N2681GRhea Higher Education And Aviation LLC · Prescott, AZN2682GFlying L Aircraft Inc · Fort Denaud, FLN2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeN2690GFerkin Air LLC · Caldwell, IDN2691GPulaski Airport Rental LLC · Denmark, WIN2692GPolhemus John W Jr · Bowie, TXN2695GBackcountry Guys LLC · Prescott, AZN2698GPeterson Floyd M · Lago Vista, TXN2700GSchool Of Missionary Aviation Technology Inc · Ionia, MIN2702GFeatherly Joseph D · Missoula, MTN2703GNeese Michael W · Homer, AKN2705GTrojcak Frank W · San Antonio, TXN2706GBlack Deberah L Trustee · Las Vegas, NVN2707GFluckey Gary T · Homer, AKN2711GAlexander Marshall J · Klamath Falls, ORN2713GPalmer Carroll W · Harper, ORN2714GRegistered aircraftN2717GKlotz Terrance M · Sparks, NVN2720GGenstler Jeremy A · Apple Valley, CAN2722GEpperson David C · Salt Lake City, UTFirst renewal noticeN2723GReno Timothy J · University Place, WAN2726GFarmhouse Aerospace LLC · Laurel, MTN2728BBig Island Gravity LLC · Kapaau, HIN2732GPrince Benjamin D · Lincoln, MTN2733GSkydive Ky LLC · Cecilia, KYN2734HGriebel Kyle L · Lafayette, CON2735GGaunt Galen B · Glennallen, AKN2736GFor Skies Flying Club Ltd · Martinsville, ILN2739GSwanson Gordon · Prescott, AZN2743GFleetwood Jack · Hutto, TXN2744GShelton Jeffrey A · Denali Park, AKN2746GMchugh Rick M · Enumclaw, WAN2752GZambarano Matthew C · South Hero, VTN2761GMartinell Justin E · Dell, MTN2767GBrowns Valley Aviation LLC · Utica, KYN2768GCarrion John H · Colusa, CAN2769GFraser Kevin J · Snohomish, WAN2771GWhitt Sana F III · East Quogue, NYN2776GOliver Charles D · Saint Albans, WVN2777GPacheco Randy L · Pacific Grove, CAN2780GHolden Christa · Rougemont, NCN2783GLarue Terrence W · Ellensburg, WAN2784GFlaps Up LLC · Kaysville, UTN2786GAvery John W · Fergus Falls, MNFirst renewal noticeN2787GGomez Bermudex Investments LLC · Lauderhill, FLN2788GCaldwell Gregg P · Desert Hot Springs, CAN2790GBryan Roger J · Spearfish, SDN2791GHoutte Edmund Michael DBA · Palmer, AKN2792GSpeedstar Aviation LLC · Kalispell, MTN2793GMeyer Steven D · Snohomish, WA
Back to Cessna 182B