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.
N2201ZAg-Tech Drone Service LLC · Jarvisburg, NCN2203ZAg-Tech Drone Service LLC · Jarvisburg, NCN221ENSale Reported · Batesville, INSale reported, canceledN221NAGem State Aerial Application LLC · Mountain Home, IDN224BEBranch Enterprises 7 Inc · Nyssa, ORN225TCRtk Aerial Applications LLC · Marlette, MIN226EAAgridrone Applications LLC · Belle, MON226VXWhite Tyler DBA · Lawrenceburg, TNN2306XNutrien Ag Solutions Inc · Loveland, CON230CJCji Aerial Inc · Fergus Falls, MNN230EDDrone Deploy Crop Application LLC · Hannibal, MON231CUNutrien Ag Solutions Inc · Loveland, CON240KSKv Farms LLC DBA · Manhattan, MTN243FTKaze Products Inc DBA · Scottsdale, AZN244BXAirstrike Ag LLC · Barnum, IAN244FZRegistration Pending · Hale, MORegistration pendingN244PPAppanoose Drones LLC · Moulton, IAN244QPVantage Midsouth Inc · Carlisle, ARN244UBVantage Midsouth Inc · Carlisle, ARN245LDWilbur-Ellis Company LLC · Salinas, CAN248YLRowland Robert · Midville, GAN249DCForest Drone Solutions LLC · South Hill, VAN249UE3l Ag LLC · Berne, INN250VTHabitat Solutions Management LLC · Claremore, OKN25234Great Lakes Aerial Applications LLC · Colon, MIN2531PAero Horizons LLC · Idabel, OKN254XAWessel Phillip C · Chandlerville, ILN2558COlathe Corn Company LLC · Montrose, CON256WAAnswer Ag LLC · Gowrie, IAN257GPPegasus Spray Midwest LLC · Hurdland, MON2582YDritz Drone Service LLC · Hendricks, MNN258PCBumpercrops LLC · Ridgeway, SCN260VTTake Flight Ag Solutions LLC · Waterford, CAN260WSStoll Wayne A · Corder, MON261TRRow Runner LLC · Shipman, ILN262LDDover Farms LLC · Louisville, KYN262NSIdeal Seed Solutions LLC · Rugby, NDN2645CRowland Air Chem LLC · Kite, GAN264FCKp Drone LLC · Dexter, MON2660BSale Reported · Wyndmere, NDSale reportedN266CSCanopy Air Service LLC · Germantown, MDN266DUBoreman Farms LLC · Burbank, OHN266FFElite Ag LLC · Ruma, ILN266QDLakedew Agtech LLC · Northville, MIN266ZSSale Reported · Wyndmere, NDSale reportedN267CSSwartz Caleb J · Bloomsburg, PAN267GZWassmann Matthew J · Hinckley, ILN267WPJ Perzee Farms LLC · Wheatfield, INN268MQLcg Family Farms LLC · Francesville, INN268TQLcg Family Farms LLC · Francesville, IN
Back to Xag P100 PRO