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 ('7100546')
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 ('7100546')
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.
N30595Edwards Brian L · Decatur, ILN30633Ramin Reuben F · Tomball, TXN30688Taylor Steven L · Cerritos, CAN30736Kiss George C · Bangor, PAN30776Jackson James E · Brainerd, MNN30838Evans Tyler A D · Muskogee, OKN30842Wisler Donald J · Tampa, FLN30899Registration Pending · Yorktown Heights, NYRegistration pendingN30926French Robert P · Dexter, MEN30933Jenkins Joe A · Wyoming, DEN30944Air Speed Development LLC · Helena, MTN30948Aslesen Leasin LLC · Halstad, MNN30952Tedrow Scott S · Goodrich, MIN30960Stuart John R · Taylorsville, KYN31005France Miles D · Wasilla, AKN31012Van Gorden Jeffrey L · Vestal, NYN31028R H K Of Kansas Inc · Overland Park, KSN31047Voorheis Donald R · Hemlock, MIN31065Rasmussen William J III · Mattoon, ILN31089Forss Jamey L · Ferndale, WAN31091Lomeli Angelo · Spring, TXN31741Parks Eric · Mount Dora, FLN3212PEllis Samuel F Jr · Copperas Cove, TXN32581Demio Douglas · Westbrook, CTN32604Sale Reported · Pompano Beach, FLSale reported, pending cancellationN32621Simmons Donald W · Dayton, VAN32635Smith James E Trustee · Kalispell, MTN32642Connor Terence J · West Chester, PAN32660Bendickson Carrie J · Garrison, NDN32664American Aviation II LLC · Peyton, CON32710Nelson Larry Trustee · Almena, KSN32754Maierhoffer Henry F Jr · Sylvania, GAN32809Kane Thomas Edward · Mc Alpin, FLN32811Jennings Herschel Todd · Stone Mountain, GAN32814Greene Garry D · Clermont, GAN32835Kolb Austin · Phoenixville, PAN32839Jastram Daniel P · White, GAN32848Mcgreevy Michael G · Brookline, MON32908Losey Charles N · Winfield, TNN32920James Peter L · Fennimore, WIN32966Tumbleson Shelly L · San Antonio, TXN32967Ward Jeffrey A · Waynesboro, VAN33027Wilder Russell C · East New Market, MDN33102Fort Bobby J · O Brien, FLN33105Rogers William H III · Blackshear, GAN33242Hargrave Bobby P · Lillian, ALN33252N33252 LLC · Jupiter, FLN3333LHatbox LLC · Snohomish, WAN33497Cleveland David L · Penn Yan, NYN35055Lyons James P · Fort Ogden, FL
Back to Piper J3L-65