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.
N3159FYarbrough Chad · Bloomingdale, GAN3162FSkinner Roma L · Ovilla, TXN3163FSchwab Roscoe C III · De Kalb, TXN3165FFindlay Bruce · Caro, MIN3166FShelton K Trustee · Perrysburg, OHN3167FGreen James C · Cedar Rapids, IAN3171FRockin Rt LLC · Smithfield, UTN3173FJames Pearl LLC · Norfolk, VAN3174FRozier Harold H Jr · Blackshear, GAN3175FEstes Bernard R · Bumpass, VAN3179FMoran Peter J · Como, MSN3185F85 Foxtrot LLC · Redmond, ORN3187FVolatile Aero Ventures LLC · Boulder City, NVN318CCVan Schoonhoven Nicholas R · Kent, WAN3190FTimbol Julius J · Fair Oaks, CAN3193FJcd4 Capital LLC · Birmingham, ALN3197FWhite River Land And Timber Co LLC · Greenbrier, ARN32CHHeckler Gary C · Carefree, AZN3304FStephan Pamela K · Anchorage, AKN3308FBravo Hotel LLC · Lewes, DEN3312FWill Robert J · Fall City, WAN3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeN3317FPeniston Mandy J · Chillicothe, MON3318FIsland Aero LLC · Tavernier, FLN3320FPoock Jerry D · Spencer, IAN3321FOwl Aviation LLC · Kingsport, TNN3322FCrystalline Entity · Los Angeles, CAN3323FFly The Dream LLC · Sun Prairie, WIN3326FRegistered aircraftN3329FFerguson Ryan L · Fort Collins, CON3330FEmk Trans LLC · The Dalles, ORN3335FSocorro Meraz · El Paso, TXN3337FAerolife Aviation LLC · Knox, INN3341FLani Lea Sky Tours LLC · Honolulu, HIN3342FKaradza Bosko S · Welch, MNN3343FLutes Ralph E · Shipshewana, INN3345FBrassard Alan Gaston · Durham, NCN3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZN3349FMaxfield David · Greenville, SCN3350FStrait Daniel · Sierra Vista, AZN3352FDaradici Jodi A · Gilbert, AZN3356FShroyer Scott E · Peyton, CON3359FHughes John · Almira, WAN3360FLane Glen Allen Jr · Cocoa, FLN3362FMunoz Mario · Scottsboro, ALN3364FCrouch Jeffrey Lane Jr · Grimesland, NCN3365FTimlor Inc · Warrenton, ORN3366PLccc Enterprises Inc · Jupiter, FLN3368FA&W Air LLC · Aiken, SCN3369FJ P Aero Holdings Inc · Carson City, NV
Back to Cessna 182J