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 ('2076615')
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 ('2076615')
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.
N525MA717 Aviation Holdings LLC · Holtwood, PAN525MEAir Shine LLC · Madisonville, KYN525MRB200 LLC · Zanesville, OHN525NGJjj Holdings LLC · Helena, MTN525PFHealthy Treats Co · Vero Beach, FLN525PHBond Adventures LLC · Meridian, IDN525RF525rf LLC · Williamsburg, VAN525RWAir Six LLC · Independence, OHFirst renewal noticeN525SMSftf Investments LLC · Onalaska, WIN525VEKwik Wall 1 LLC · Springfield, ILN525VPFractional Jet Services Of Oklahoma LLC · Oklahoma City, OKN525WDStarjet Holdings LLC · Cocoa Beach, FLN525ZZCpd Properties LLC · Macon, GAN526DVAutomall Aviation LLC · Lakeland, FLN529PCMervyn Lapin Aircraft LLC · Vail, CON533FBz/Rlb LLC · Houston, TXN535JFD & H Aviation LLC · Smithfield, NCN54SLMeador Aviation LLC · Pocatello, IDN55KTHeaton Air LLC · Goleta, CAN569DMShenandoah Equipment LLC · Midland, TXN571SBBp-Residential LLC · Dallas, TXN576SCFw Cielo LLC · Canton, OHN57FL525a-0198 LLC · Sparks, NVN585EPSongbird LLC · Bloomfield Hills, MIN586FDTimber Ridge Aviation LLC · Springfield, MON58SJSeastar Inc · Carmel, INN592DRWestern Oilfields Supply Co · Bakersfield, CAN595DMRobinson James · Seabrook, TXN5YDN5yd LLC · Sheridan, WYN604LJHealthincent LLC · Memphis, TNN605TJSioux Aircraft LLC · Sioux Falls, SDN612JCKaty Partnership Leasing LLC · Watertown, SDN614HBHts Air LLC · Amarillo, TXN615FBFbk Aviation LLC · Nashville, TNN618WPSmi Air LLC · Wilmington, DEN62RLJmj Aviation LLC · Camden, ARN630TFHorizon Aviation LLC · Chicago, ILN639TCNowak Aviation Inc · Fall River, MAN642WWN642ww LLC · Swainsboro, GAN653BBRegistration Pending · West Fargo, NDRegistration pendingN65CKCuro Group LLC · Chesterfield, MON660SAlpine II LLC · Boulder, CON675ABUS Eagle Aviation LLC · Miamisburg, OHN67CCHigh Capisco LLC · Baton Rouge, LAN698TCAva Aviation LLC · Rochester, MIN69WHRegistered aircraftN6AENewton Air LLC · Saint Louis, MON6ZEDmg Aviation LLC · Miami, FLN701EXPonderosa Aviation LLC · San Francisco, CAN701SFT Triple R Inc · Santa Teresa, NM
Back to Cessna 525A