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 ('2072714')
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 ('2072714')
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.
N3353UWieser Ranch Inc · Vernon, CON3357URunway Ventures LLC · Salida, CON3358UBratcher Michael · Elizabethtown, KYN3360UBailes Ernest J IV · Shepherd, TXN3361UKelleher Chuck W · Shelby, MTN3362UGilliland Mcclaflin Wayne D · Powell, WYN3364UPalladino Frank · Castleton, NYN3366UAbraham Alan · Pilot Point, TXN3367UKellogg David J · Marshall, MIN3368UZeigler Ryan C · The Dalles, ORN3370UBriannas Wings Of Passion Foundation Inc · Magalia, CAN3372ULeading Edge Operations LLC · Knoxville, TNN3374UMurphy & Son Construction Inc · Brownsville, VTN3378UJeppson Edward M · Nephi, UTN3379UJames Mccullough · Hempstead, TXN3381UCenter Of Excellence Corp · Cheyenne, WYN3387USkynick Enterprises Inc · Tarzana, CAN3388UMenard Charles H · Grand Blanc, MIN3389UThompson Anthony D Trustee · Rockwall, TXN3399UWorley Dan J · Perris, CAN3403ULintvedt Brian · Presho, SDN3407UNote Clayton Rex · Eagle Point, ORN3410UWegman Aviation LLC · Kenmore, NYN3411USutton Aircraft Salvage LLC · Palmer, AKN3417UHubnik Andrew T · College Station, TXN3418UHyer Randall N · Doylestown, PAN3419USpanos Richard P · Brooksville, FLN3421USchuster Timothy A · Carrington, NDN3422UK & M Aircraft LLC · Granbury, TXN3425U4appraisals LLC · Odessa, TXN3428UHcp Aviation LLC · Waco, TXN3434UHale William R · Covina, CAN3435UJackson Terry W · Lewisburg, TNN3438UGrau Gary Wayne Jr · Yelm, WAN3439UFlycatcher Aviation LLC · Purcell, OKN3440UPlane Joy LLC · Payson, AZN3441UDemeyer Scott M · Olympia, WAN3443UHall George K · Cathedral City, CAN3444ULepton Films LLC · Tarzana, CAN3446UTempus Morgan C · Cameron Park, CAN3448UHigh Planes Flyers Inc · Fort Collins, CON3449UHicks Brian Joseph · Shingle Springs, CAN3451UJohnson Kevin S · Burns, ORN3452UNordland Tom Trustee · Boulder Junction, WIN3455UBown George Morgan · Shady Shores, TXN3456UWright James R · Georgetown, CAN3457USelway Aviation Inc · Missoula, MTN3459UWalker Cody · Jacksboro, TXN3463UYancey Cameron L · Anchorage, AKN3464UEvergreen Holdings LLC · Missoula, MT
Back to Cessna 182F