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 ('06102D3')
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 ('06102D3')
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.
N113SLState Line Drone Services LLC · Clinton, INN1141LLimoneira Co · Santa Paula, CAN114AAAlms Tyler DBA · York, NEN114JBRatcliff Brian W · Easton, KSN115GWDyson Earl · Queenstown, MDN117RMRm Precision Ag LLC · Troy, KSN117WFHouff Corporation · Weyers Cave, VAN1185KTb2 Drones LLC · Guymon, OKN118TCTriple Creek Farm And Ranch LLC · Coeur D Alene, IDN1191WRegistered aircraftAssigned, pending cancellationN1192KCropic Ag Solutions LLC · Williamston, MIN1193CClear Prop Aerial Solutions LLC · Orleans, INN119DMJohnson-Wagner Farms LLC · Camden, INN119SFShinkle Farms Inc · Waynesville, OHN119TAAgrivision LLC · Winona, MNN1202SC&S Agri Drone Solutions LLC · Chillicothe, OHN1203SSublette Aerial Services LLC · Sublette, ILN120EACp Agronomy LLC · Dothan, ALN120HSC&S Agri Drone Solutions LLC · Chillicothe, OHN1216FRegistration Pending · Lowell, INRegistration pendingN1216HMeadows Glynn Wayde · Bonifay, FLN1220YBurnett Dairy Cooperative · Grantsburg, WIN1222DDavis Zach W · Winfield, IAN122ANSynergy Nurseries Inc · Rickreall, ORN122DETop Flight Ag LLC · Traer, IAN122TATexag Drone Solutions LLC · Fort Worth, TXN1238GMaverick Drone Systems LLC · Savage, MNN1240QPrecision Aerial Applicators LLC · Polson, MTN1248UPrecision Aerial Applicators LLC · Polson, MTN1249QEagle Eye Application LLC · Smith Center, KSN124ACAerial Crop Services LLC · East Prairie, MON124WWWestern Wings Drone Service LLC · Dayton, WYN1255WNorthern Nevada Public Health · Reno, NVN1256TGordon Troy R DBA · Mound City, MON125MAAiroterra LLC · Ellensburg, WAN125NKNorman Kramer E · Yankton, SDN1265MMarett Everett L · Lawrenceburg, KYN127WJJordan Jesse · Bell Buckle, TNN1280HH&H Ag Service LLC · Carlisle, KYN1281VBoot Justin · Tracy, IAN1286HSi Aerial Ag LLC · Vergennes, ILN1288BBrumfield Benjamin D · Winchester, INN128ZZPanhandle Uas LLC · Altha, FLN1292TTwin Lakes Farm II · Parkin, ARN1296HRegistration Pending · Walthill, NERegistration pendingN1307BBurgin Gary R · Memphis, INN130KBAgro Drone Services LLC · Windsor, CON1315HHeintz Kevin · Addieville, ILN1318NHall Ag Services LLC · Troy, MON131BHBig Horn Pest Control · Powell, WY
Back to DJI AGRAS T40