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 ('06102FP')
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 ('06102FP')
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.
N623WWWhitten & Whitten Inc · Valley Park, MSN631DCRhoads Brothers Farm · Bloomsburg, PAN640RARooted Ag Drone Services LLC · Higginsville, MON654EHRegistered aircraftN-number assigned, not yet registeredN657GRFlokstra Andrew · Marshall, MIN660RCRc Agriculture LLC · Burley, IDN663DCMoffat County Weed And Pest Management · Craig, CON666KPProdrone Ag LLC · Heron Lake, MNN687DCKenkel Connor · Dunlap, IAN68SAStratton Air And Ground LLC · Tulare, CAN692CMCodeman LLC · Lake Arthur, LAN693DCTake Flight Ag Solutions LLC · Waterford, CAN693LKViola Drone Services LLC · Audubon, IAN694LKViola Drone Services LLC · Audubon, IAN703ECCsc Agridrone LLC · Delaplaine, ARN704DCWassmann Matthew · Hinckley, ILN705ECCsc Agri Drone LLC · Delaplaine, ARN708SBSb Strategies LLC · Flowood, MSN709DMRegistration Pending · Searsboro, IARegistration pendingN7102Gvm Inc · Biglerville, PAN7103Gvm Inc · Biglerville, PAN7104Frey Agricultural Products Inc · Mount Airy, MDN710DCSale Reported · Lake City, IASale reportedN710DERegistration Pending · Cedar Falls, IARegistration pendingN716LBAg Drone Specialists LLC · Lewistown, MON7250Accelerate Aerial LLC · Worden, ILN7251Accelerate Aerial LLC · Worden, ILN726NALegacy Ag Solutions LLC · Terre Haute, INN728KRFirelands Farmstead Operations LLC · Greenwich, OHN728MWWinston LLC DBA · Carrington, NDN73102Tschumperlin Kiel · Sauk Centre, MNN732SASouthern Ag Solutions LLC · Fayetteville, OHN7331BHenry Ag LLC · Zanesfield, OHN7366MDragon Drone Service LLC · Union City, MIN736DCFlyemm LLC · West Des Moines, IAN749EEEdko LLC · Bossier City, LAN751EEEdko LLC · Bossier City, LAN755DDDld Customs LLC · Dawn, MON760TSTurf And Soil Management Contract Services LLC · Alvarado, TXN768HSSale Reported · Windsor, COSale reportedN772RLJohnson Robert C · Dickerson, MDN781CHRegistered aircraftN-number assigned (non-type certificated), not yet registeredN782EEStiles Equipment LLC · Marianna, ARN784ZHRegistered aircraftN-number assigned (non-type certificated), not yet registeredN785HDHeartland Drone Services LLC · Wichita, KSN790LCRegistration Pending · Wausau, WIRegistration pendingN79XAMidwest Air LLC · Peebles, OHN808SVSunny Valley Aerial LLC · Hayes Center, NEN80XAMidwest Air LLC · Peebles, OHN811SUSouthern Ute Indian Tribe Range Division · Ignacio, CO
Back to Xag P100 PRO