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 ('2072424')
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 ('2072424')
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.
N3722RRegistration Pending · Wallace, NCRegistration pendingN3724FRapp Timothy · Fairfield, MTN3726RJrs Appliance Disposal Inc · Inver Grove Hts, MNN3727FCoray David A · Soldotna, AKN3728F316 Aviation LLC · Saint Clair Shores, MIN3728RRaks Aviation LLC · Hillsborough, NJN3729FPena Miguel A · Live Oak, FLN3730RChief Joseph Flyers Inc · Joseph, ORN3733FBurch Samuel Owen · Roxboro, NCN3733RCouick Donald Michael · Monroe, NCN3735FEb Flight Training LLC · Daytona Beach, FLN3739FSchlueter Helmuth K · San Tan Valley, AZN3739RRusak Robert J · Paris, TXN3740FLavalley Asset Management · Potsdam, NYN3740RRhodes Samuel R · Bonne Terre, MON3741FMclanahan John P · Culpeper, VAN3741RAbecca Corp · Jackson, MIN3743FSchultz Kathryn N · Madison Heights, MIN3745RDodds Timothy E · Salmon, IDN3746RPearson Eric · Wills Point, TXN3748FMcdonald David R · Duluth, MNN3748RRotormate LLC · Royse City, TXN3749FLeduc Kramer LLC · Live Oak, FLN3750FGrubbs Richard T · Spring, TXN3750RN3750r LLC · Guthrie, OKN3752FCopper River Airmotive LLC · Copper Center, AKN3752RMccoy Gregory K · Wichita, KSN3753RCounts Sean M · Largo, FLN3754FTrees Joshua S · Italy, TXN3754RVandiver James A · Rome City, INN3758FTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTN3758RDrager Timothy L · Pottstown, PAN3763RPrimo Aviation LLC · Collierville, TNN3765RLevin Robert · Roseburg, ORN3768RStretz Scott P · Lees Summit, MON3770FSchoenberger Lance · Shakopee, MNN3770RBowery Michael P · Quinton, VAN3771RMccay Brian D · Earlysville, VAN3772RRiver Town Aviation LLC · Williamstown, WVN3773RBlair Richard J · Medina, OHN3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationN3778RSwede Aviation LLC · Tucson, AZN3779FTiraphatna Jittakorn · Arlington, TXN377MMAerowood Aviation LLC · Monroe, NCN3780FBoswell Cecil C · Columbus, MSN3781FStoller Aircraft LLC · Sterling, OHN3782F82 Foxtrot LLC · Tucson, AZN3784RHaver Andrew A · West Bend, WIN3785FFloyd Mark E · Adairsville, GAN3786RPutnam Richard E · Redmond, WA
Back to Cessna 172H