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 ('8682000')
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 ('8682000')
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.
N715VTnt Operations LLC · Missoula, MTN716MAMcclelland John J · Edinburg, TXN71EEKalisetsi LLC · Hillsborough, CAN71WJTbm One Aviation LLC · Milford, CTN720CJValiair Limited Co Trustee · Casper, WYN720MJAardsma Mark · Foosland, ILN720WAWhiskey Alpha LLC · Lexington, KYN721MBDgw Enterprises LLC · Edina, MNN721SRNcs Aviation LLC · Bemidji, MNN724DMBusker Aviation LLC · Detroit Lakes, MNN738TSThree Sisters Aviation LLC · Olympia, WAN744AMBuenting John E · Sylva, NCN74MASierra Tango Air LLC · Sycamore, ILN750ABNpa Aviation LLC · Lafayette, LAN753BLBlackjack Express 340 LLC · Santa Barbara, CAN753CAMoon Mountain Montana LLC · Missoula, MTN755DMMdst Aircraft Leasing LLC · Ripon, WIN755ZR8992 Air LLC · Whitman, NEN756TWKehl Rd LLC · Sixes, ORN759XTBte Investments LLC · Howell, MIN75BSPpsp LLC · Palo Alto, CAN75BTAbide Aviation LLC · Wilmington, DEN762RSSa Leasing LLC · Newark, DEN767HPBarringer Aviation LLC · Waxhaw, NCN769JSSpurlock Benjamin · Eugene, ORN770DCRam Aviation LLC · Alexandria, LAN772AM2020 Aviation LLC · Wayne, PAN772KHKish Aviation LLC · Meridian, IDN772WWL39 LLC · Far Hills, NJN774AWTas320 LLC · Missoula, MTN776RMPclb Aviation LLC · Idaho Falls, IDN777FXLcg One LLC · San Diego, CAN777XASouthern Aircraft Consultancy Inc Trustee · Casper, WYN7790JTbm-1077 LLC · Diamond Point, NYN77LGFly High Line LLC · Shelby, OHN783BBAltura Air LLC · West Barnstable, MAN785MAAircraft Rental Services Inc · Escanaba, MIN788RBFlight Levels LLC · Evergreen, CON788RRNaquin Precision Earth Moving Inc · Yuma, AZN790CABig Air Productions Of Fl LLC · Niceville, FLN790MCMccracken Holdings LLC · Fort Worth, TXN790TBKnights Aviation LLC · Kirkland, WAN7SASla-Flyer LLC · Steamboat Springs, CON8083Magnum Air LLC · West Fargo, NDN808JWGriffin David · Houston, TXN809MCJmc Communities I LLC · Saint Petersburg, FLN813GGTvpx Trust Co LLC Trustee · North Salt Lake, UTN815KInterstate Air LLC · Saint Louis, MON815RDDietrich Richard C · Cleveland Heights, OHN817HFHubbard James D Jr · Fort Worth, TX
Back to Socata TBM 700