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 ('2072724')
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 ('2072724')
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.
N2789QCenterline LLC · Yankton, SDN2790QArthur Lloyd T · Greenfield, INN2792QPalmer Paul F · Donnelly, IDN2794QVincer Way LLC · Centennial, CON2804RBarnhill Gregory L · Leawood, KSN2808RInman Matthew · Gallatin, TNN2809RTerwillegar Charles E · Renton, WAN2810RSeller Mark E · Hutchinson, MNN2812RBullin Keith · Bryan, TXN2814RCypress Aviation Inc · Naples, FLN2815RKimmel Aviation Insurance Agency Inc · Greenwood, MSN2820RHutter Karl G · Reno, NVN2821RNielson David L Trustee · Anchorage, AKN2825ROjeda Holdings LLC · Gainesville, GAN2830RCae Flying Club Of Ohio · Toledo, OHN2832RMabe Bradley L · Cascade, IDN2833RRegistered aircraftN2834RPence Levi B · Quincy, CAN2836RWorthington David C Trustee · Saratoga, WYN2838RFairbanks Mark J · Kotzebue, AKN2843RDrandike Aviation LLC · Scottsdale, AZN2845RCarlson Kevin J · Dunedin, FLN2847RCashman Jeremiah P · Bozeman, MTN2848RBoccaccio Peter A · Burke, SDN2849RKoehler Paul Jeffrey · Perkasie, PAN2850RNorcal Skydiving LLC · Cloverdale, CAN2851RRegistered aircraftN2852RBaylor Gary J · Cheshire, CTN2853RSmith Thomas D · Green Valley, AZN2856RDennis Billy C Jr · Scottsdale, AZN2857RWilson Gary C · Lake Tapps, WAN2858RWetter Kristian · Fort Myers, FLN2860RStoddard Bruce R · Tucson, AZN2862RGuthrie Devin L · Sallisaw, OKN2869RDiehl Steven L · Martinsburg, PAN2871RBlue Ridge Flyers Inc · Leesburg, VAN2880RPhelps Thomas J · Orem, UTN2883RCallegari Sergio P · Reno, NVN2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeN2887RNaylor Michael Scott · Modesto, CAN2889RAircraft Structural Repair Inc · Hamilton, MTN288TMSlaba Mark E · Arcadia, FLN2892RBuenafe Constance Ann · Santa Fe, NMN2897RGervase Russell G · Farmington, NMN28ERSmith John C · Germantown, TNN295GTMedina-Solla Edwin O · Carolina, PRN3000QFlying H Enterprises · Santa Fe, NMN3002QJaeger Christopher E · Normandy Park, WAN3006QHarrington Michael L · Twin Falls, IDN3014QBilly B Services LLC · Cornelia, GA
Back to Cessna 182K