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.
N668W231pb LLC · San Francisco, CAN671EAMjd58 LLC · Newark, DEN67BPTbm N67bp Inc Trustee · Wilmington, DEN67VVRivergates Ivy Warp LLC · Boca Raton, FLN688MAPoc One LLC · South Hill, VAN68TFRegistered aircraftN690CKlass Investments LLC · Marksville, LAN693MACurrie Partners Inc · San Diego, CAN694PB1a Asset Holdings LLC · Novi, MIN69CVDeliberate Air LLC · Brigham City, UTN700ADRkefs LLC · Big Lake, MNN700ANAi Kinetics LLC · Los Altos, CAN700APSutton Bay Leasing LLC · Excelsior, MNN700AYKellman Act Services Inc · Pacific Palisades, CAN700BFFoxtrot Transportation LLC · Saint Charles, MON700BMMason Amelia Holdings LLC · Boerne, TXN700BNBostic Capital Group LLC · Prestonsburg, KYN700BQMjm Aviation LLC · Fowler, CAN700BSPark Rapids Avionics Inc · Park Rapids, MNN700CFN7880l LLC · Port Charlotte, FLN700CLJupiter Equipment Leasing Inc · Garland, TXN700CSSocata 109 Inc Trustee · Wilmington, DEN700CTPatriot Contractors LLC · North Las Vegas, NVN700CVIlmo Adventures LLC · Kalispell, MTN700CZNexus Surgical Innovations Inc · Bozeman, MTN700DEPhoenix Trailers Aviation LLC · East Jordan, MIN700DMClearance Clarence LLC · Lubbock, TXN700DTNorth Coast Ventures LLC · Wilmington, DEN700DZTwo Oscar Three LLC · Saint Helena, CAN700EBEcho Bravo LLC · Geneva, ILN700EJLyv 26 Inc Trustee · Wilmington, DEN700ELAir Twinlite Inc Trustee · Wilmington, DEN700ENLantech.Com LLC · Louisville, KYN700ERBa Transportation Inc · Colonial Heights, VAN700EVAl & Zal Corp · Wilmington, DEN700EZDbw Aviation LLC · Anaheim, CAN700GEArdmore Aviation LLC · Russell Twp, OHN700GJRockland Key Aviation Inc · Wilmington, DEN700GKPeterson Air LLC · Austin, TXN700GNTinman LLC · Raleigh, NCN700GTJdr Logitstics LLC · Tucson, AZN700GVE6 Aviation LLC · Scott City, KSN700HKDsl LLC · Las Vegas, NVN700HLDoss Michael G · Spicewood, TXFirst renewal noticeN700HNHartman Doyle · Aspen, CON700HYClear Blue Sky Aviation LLC · Hilton Head Island, SCN700JJIndependent Monitoring LLC · Los Altos, CAN700JNMassry LLC · Casper, WYN700JVBouliaga Fly Inc Trustee · Wilmington, DEN700KHHttrr LLC · Austin, TX
Back to Socata TBM 700