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.
N700LGJackson Aviation Inc · Louisville, MSN700LLGf Air LLC · Las Vegas, NVN700LTEvans Rock Aviation LLC · Morehead City, NCN700MXD Fla Aviation LLC · Bowling Green, KYN700MYGpp Holdings LLC · Edmonds, WAN700NDGriffin Aero LLC · Fargo, NDN700NNIntegrity Aircraft Title Holdings LLC · Portland, ORN700PTOdl LLC · Oshkosh, WIN700PWBohica Consulting Services Inc · Boulder City, NVN700PXBjc Holdings Inc · Wheaton, ILN700QQTbm 700 277 Inc Trustee · Wilmington, DEN700QTBarnes Aviation LLC · Miami, FLN700RESky Hawk LLC · Hamilton, MTN700RKBroodo Jack · Midland, MIN700RPRepco Air LLC · Tarpon Springs, FLN700SExciting Aviation LLC · Southport, CTN700SPCream & Crimson Aviation LLC · Bloomington, INN700SXRgt LLC · Madera, CAN700SYJvg Leasing Co · Monrovia, MDN700TJHerrmann Holdings Inc · Cottonwood, CAN700TKN303jw-Rr LLC · Denver, CON700TLCosmos Holdings Group LLC · Newark, DEN700VBAircraft Guaranty Corp Trustee · Oklahoma City, OKN700VMEden Partners LLC · Edina, MNN700VVMiddlefield Farm And Garden Co · Middlefield, OHN700WEJohnson Dean M · New Haven, CTN700WFSky West Aviation Inc Trustee · Albuquerque, NMN700WKTwindustries LLC · Montrose, CON700WTPemetic Ac LLC · Northeast Harbor, MEN700YNPacific Wings Holdings LLC · Los Altos Hills, CAN700ZFLardon Leasing LLC · Crossville, TNN700ZZEastern Aviation Fuels Inc · New Bern, NCN701AVTango Alpha Sierra LLC · Austin, TXN701CNScouts Rest Ranch LLC · Darby, MTN701JFJ Fergus Inc · Lewis Center, OHN702AALantech Leasing LLC · Louisville, KYN702AROro Grande Mining Claims LLC · Anchorage, AKN702UT400 Knot Aviation LLC · Amarillo, TXN702WMWalker Manufacturing Co · Fort Collins, CON707AVCarvair LLC · New York, NYN707FBBolea Air Inc · Morgan Hill, CAN708CGGbo-Air LLC · Hopkinsville, KYN708EFDejong Merritt · Newburgh, INN708JPFly696cc LLC · Sisters, ORN709MMYl Management LLC · Oak Hill, VAN70AVQualitair LLC Trustee · MichelstadtN70LTBarren Troy Aviation LLC · Centennial, CON711PMVinton Aero LLC · Cedar Springs, MIN711PPWalsh Stephen Robert · Rochester, NYN712LRDz Holdings LLC · Hauppauge, NY
Back to Socata TBM 700